Step 1: Configure development environment for pyodbc Python development
Connect to SQL Database by using Python - pyodbc on Windows:
Download Python installer.
If your machine does not have Python, install it. Go to the Python download page and download the appropriate installer. For example, if you are on a 64-bit machine, download the Python 2.7 or 3.7 (x64) installer.
Install Python. Once the installer is downloaded, do the following steps: a. Double-click the file to start the installer. b. Select your language, and agree to the terms. c. Follow the instructions on the screen and Python should be installed on your computer. d. You can verify that Python is installed by going to
py -v(for 3.x)
Open cmd.exe as an administrator
Install pyodbc using pip - Python package manager (Replace
C:\Python27\Scriptswith your installed Python path)
> cd C:\Python27\Scripts > pip install pyodbc
Connect to SQL Database by using Python - pyodbc:
> sudo -H pip install pyodbc