How to connect to SQL Server from Python Flask?

Question

I have been trying to connect to SQL Server from Flask but with no luck.

I can connect to DB when i try in my Local Machine and it works perfectly fine, but when i try to connect from VM/Remote Desktop, i see the below error.

I have spent lot of time trying to figure out the issue and for solution, but no luck. I suspect something should be with firewalls or security.

Thanks in Advance for help.

conn = pyodbc.connect('Driver={SQL Server};'
        'Server=DEV001;'
        'Database=ZXCZ;'
        'user=gendb;'
        'Password=qwe123;')

OperationalError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]SSL Security error (18) (SQLDriverConnect); 
[08001] [Microsoft][ODBC SQL Server Driver]
[DBNETLIB]ConnectionOpen (SECCreateCredentials()). (1); 
[08001] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')

Are you sure {SQL Server} is the right driver? github.com/mkleehammer/pyodbc/wiki/… — Dan
– Dan, Commented Feb 19, 2020 at 15:00
{SQL Server} worked fine when i try in my Local Machine, but i see issues only when i try in Virtual Machine. — Punith
– Punith, Commented Feb 19, 2020 at 15:15
Be sure to use appropriate ODBC parameters. Use uid and pwd instead of user and password. Also, remember a virtual machine is different environment than local machine. It must have network or remote access to database and installed ODBC drivers. — Parfait
– Parfait, Commented Feb 19, 2020 at 15:33
The VM could have different drivers to your local machine... — Dan
– Dan, Commented Feb 19, 2020 at 17:26

mauridb · Accepted Answer · 2020-02-21 20:27:52Z

2

Make sure you use the latest version of ODBC, that you can find here:

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server

At the bottom of the page you'll also find a link to Installation document, in case you're installing in on something different than Windows.

Also, the connection string should look like

DRIVER={ODBC Driver 17 for SQL Server};SERVER=;DATABASE=;UID=;PWD=;

answered Feb 21, 2020 at 20:27

mauridb

1,58911 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to connect to SQL Server from Python Flask?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related