Weird error with driver - Data source name not found and no default driver specified

mkleehammer / pyodbc

Python ODBC bridge

https://github.com/mkleehammer/pyodbc/wiki

MIT No Attribution

2.88k stars 562 forks source link

Weird error with driver - Data source name not found and no default driver specified #1101

Closed marcelo-franceschini closed 1 year ago

marcelo-franceschini commented 1 year ago

Environment

Python: 3.9.13 (x64)
pyodbc: 4.0.34
OS: Windows 10 (x64) 21H2 - OS Build 19044.2006
DB: SQL Server Developer 2019.150.2000.5
driver: ODBC Driver 18 for SQL Server

Issue

Hello everyone :) I'm having this weird issue with my driver. I tried "everything". Reinstalled Python, ODBC, Driver e etc. Not sure what is wrong.

marcelo-franceschini commented 1 year ago

connection = pyodbc.connect( 'DRIVER={ODBC Driver 18 for SQL Server};' 'SERVER=localhost;' 'DATABASE=tcc;' 'UID=marcelo;' 'PWD=senhabanco;' 'TrustServerCertificate=yes' )