Python did not find the data source name and did not specify a default driver

Recently in the Python connection to SQL Server read the database, read the data in the local computer normal, but must not be sent to the server when the error "did not find the data source name and no default driver", later found to be due to the problem of the data source, resolved as follows:

The driver is PYODBC.

The connection method is as follows:

　

The problem occurs because driver "SQL Server Native Client 11.0" and the ODBC configuration of the data source on the server are consistent. The server version is 10, so you can change it to match.

　

Python did not find the data source name and did not specify a default driver