When you attempt to connect to a SQL version 6.5-based server and your DSN to that server is set to use multiprotocol, you may receive the following error message:
Connection failed: SQLState: '01000', SQL Server Error:0, [Microsoft][ODBC SQL Server Driver][Multi-Protocol], Connection failed:, SQL State: '08s01', SQL Server Error:0, [Microsoft][ODBC SQL Server Driver] Communication link failure
To work around this problem, connect to the SQL version 6.5-based server using the named pipes protocol from the client:
- Click Start, point to Settings, click Control Panel, and then double-click ODBC Data Sources (32bit).
- Double-click the DSN that is generating the error message, click Next, click Client Configuration, and then click Named Pipes in the Add Network Library box to select it as the network library.
- Click Next, and then click Finish to save the DSN.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem is specific to SQL version 6.5-based servers, and this problem does not occur in SQL version 7.0-based servers.
ID članka: 232138 - posljednja izmjena: 24. sij 2007. - verzija: 1