Connection string to SQL server with Python pypyodbc

python sql-server database-connection pypyodbc
Tal picture Tal · Jun 13, 2017 · Viewed 17.4k times · Source

I'm using this connection string but something is wrong.

conn = pyodbc.connect
(DRIVER={SQL Server};SERVER=localhost;DATABASE=test;UID=YYY;PWD=XXXX)
connection.close()

How can I do this?

Answer

Michael Malone picture Michael Malone · Sep 7, 2018

If you're on Linux or macOS then you'll need to install the MS ODBC Driver, available on their website https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017

Then use the Driver String {ODBC Driver 17 for SQL Server}

connection_string = "DRIVER={ODBC Driver 17 for SQL Server};Server=..."

Related questions

How do I connect to a SQL server database with python?

Im trying to conennect to an sql database that its already created an that its located on a server. How can I connect to this database using python. Ive tried using java but I cant seem to get working either.

Read More
SQL Server temp table not available in pyodbc code

I'm running a series of complex sql queries in python and it involves temp tables. My auto-commit method doesn't seem to be working to retrieve the data from the temp table. The code snippet I'm using below and this is …

Read More
Retrieving Data from SQL Using pyodbc

I am trying to retrieve data from an SQL server using pyodbc and print it in a table using Python. However, I can only seem to retrieve the column name and the data type and stuff like that, not the …

Read More