SQL Server express cannot establish ODBC (error code 67 and 17)

Description:

When you create ODBC in the control panel, errors 67 and 17 are always displayed, indicating that SQL Server (actually express) is unavailable.

 

Cause:

The SQL Server Browser of SQL Server Express is not started.

If the installation is express rather than SQL Server, many operations on the control panel are the same as those on SQL Server (it may be a problem with ms. In many cases, they are too lazy to distinguish the two ), but there is a significant difference below: Previously when selecting a server, it was generally <local> or a computer name such as a CY-PC, But now you need to select a CY-PC/Express. If only the <local> and CY-PC are found, do not manually enter ~ /Express, but indicates that this service is not enabled. If this parameter is set, an error occurs.

 

Solution:

To the service, start SQL Sever broswer, and then establish ODBC. It will be directly found from the drop-down list ~ /Express, select it and everything is normal.