Connecting to localdb from pyodbc

Question

Tried all sorts of variations to connect from python pyodbc to my local SQL Server

Also tried doing the \ escape

'Server=(LocalDB)\\MSSQLLocalDB;'
'UID=domain\\uname;'

but still get this error

I am able to connect to the same localdb from SSMS.

this is the error message screenshot

Answer 1

First you should choose between providing uid/password and Trusted_Connection I would suggest you to construct the connection string as follows:

"DRIVER={SQL Server};SERVER=localhost;DATABASE=TestDB;UID=$user;PWD=$password"

Furthermore, if localhost does not solve your issue you can use (local) also and for a named instance localhost\$instance_name, you do not have to put 2 backslashes. Last I would strongly suggest you to upgrade your driver to the latest version. As you can easily set it in the connection string as follows:

"DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost;DATABASE=TestDB;UID=$user;PWD=$password"

In addition you can check this link

Answer 2

Connecting to SQL Server Express Edition LocalDb requires an updated driver. The legacy ODBC driver can't do it. So either get the new ODBC Driver, or download SQL Server Express (the Windows Service package).