Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

python pyodbc install

# Linux fix
apt-get update
apt-get install unixodbc-dev
pip install pyodbc

#Windows 
1- Download from this link https://www.python.org/downloads/release/python-3104/  # Depending on version you can pur your own instead of 3104 which is python3.10.4
 For example, if you are on a 64-bit machine, download the Python 2.7 or 3.10 (x64) installer.

2- 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 to install Python on your computer.
 d- You can verify that Python is installed by going to a command prompt and running python -V or py -V (for 3.x). You can also search for Python in the start menu.
3 - Install the Microsoft ODBC Driver for SQL Server on Windows. https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15#download-for-windows

4- Open cmd.exe as an administrator.

5- Install pyodbc using pip - Python package manager. (Replace C:Python27Scripts with your installed Python path)
Comment

PREVIOUS NEXT
Code Example
Python :: plot specific columns pandas 
Python :: find table with class beautifulsoup 
Python :: write multiple df to excel pandas 
Python :: python check if a file is empty 
Python :: opencv draw two images side by side 
Python :: flask run app reset on change 
Python :: set cuda visible devices python 
Python :: check if string url python 
Python :: make a zero list python 
Python :: print image python 
Python :: python function to print random number 
Python :: pip install arcpy python 3 
Python :: get max float value python 
Python :: python alphabet 
Python :: python current date and time 
Python :: how to create dynamic variable names in python 
Python :: record video with python 
Python :: pandas left join 
Python :: how to save plot in python 
Python :: python run 2 functions at the same time 
Python :: how to print a random part of a list in python 
Python :: make length string in pandas 
Python :: remove nan from list python 
Python :: set index to column pandas 
Python :: pandas sum multiple columns groupby 
Python :: how to refresh windows 10 with python 
Python :: plotly grid lines color 
Python :: python read file csv 
Python :: get current month name python 
Python :: matplotlib plot adjust margins 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =