Python to SQL Connection. Trying to push pandas dataframe to SQL Server

Question

Anyone know how to solve this error? Trying to connect to Azure SQL Server.

Thanks a ton!

InterfaceError: (pyodbc.InterfaceError) ('IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') (Background on this error at: http://sqlalche.me/e/rvf5)

Can you show some demo code? I can use sqlalche to connect my azure mssql. — Ivan Glasenberg
– Ivan Glasenberg, Commented Dec 12, 2018 at 0:44
If the answer below works for you, could you help mark it? thanks very much. — Ivan Glasenberg
– Ivan Glasenberg, Commented Dec 14, 2018 at 10:02

Ivan Glasenberg · Accepted Answer · 2018-12-12 07:33:19Z

1

Without your code, but just from the error message, it seams that there is some issue with your connection string.

You can use the code below for test:

import pyodbc
from sqlalchemy import create_engine
import urllib

params = urllib.quote_plus \
(r'Driver={ODBC Driver 13 for SQL Server};Server=tcp:yourDBServerName.database.windows.net,1433;Database=dbname;Uid=username@dbserverName;Pwd=xxx;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;')
conn_str = 'mssql+pyodbc:///?odbc_connect={}'.format(params)
engine_azure = create_engine(conn_str,echo=True)

print('connection is ok')

Hope it helps. And please let me know if any further issue.

answered Dec 12, 2018 at 7:33

Ivan Glasenberg

30.3k2 gold badges56 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Python to SQL Connection. Trying to push pandas dataframe to SQL Server

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