VIA Provider error in SQL Server 2005
-
Dear Friends I have installed SQl Server 2005 on windows xp sp2 but when i add SQL Native Client in ODBC i get the following message SQLState: '8001' SQL Server Error: 126 [Microsoft][SQL Native Client]VIA Provider: The specified module could not be found. Connection Failed: SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Native Client]Login timeout expired Connection Failed: SQLState: '8001' SQL Server Error: 126 [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. TESTS FAILED! Please guide me as to what can be done to solve the problem i am not able to connect through the application developed in vb.net. thnxs.
-
Dear Friends I have installed SQl Server 2005 on windows xp sp2 but when i add SQL Native Client in ODBC i get the following message SQLState: '8001' SQL Server Error: 126 [Microsoft][SQL Native Client]VIA Provider: The specified module could not be found. Connection Failed: SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Native Client]Login timeout expired Connection Failed: SQLState: '8001' SQL Server Error: 126 [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. TESTS FAILED! Please guide me as to what can be done to solve the problem i am not able to connect through the application developed in vb.net. thnxs.
You probably don't have the VIA (Virtual Interface Adapter) hardware required to use the VIA protocol. You can force the network library to be used by specifying "Network Library" in the connection string - for example, TCP/IP is 'dbmssocn'. If you're using VB.NET to connect to SQL Server you should use the SqlConnection class and its family of associated classes, not ODBC.
DoEvents: Generating unexpected recursion since 1991
-
You probably don't have the VIA (Virtual Interface Adapter) hardware required to use the VIA protocol. You can force the network library to be used by specifying "Network Library" in the connection string - for example, TCP/IP is 'dbmssocn'. If you're using VB.NET to connect to SQL Server you should use the SqlConnection class and its family of associated classes, not ODBC.
DoEvents: Generating unexpected recursion since 1991
Thanks, but sql is not configured in ODBC Manager so I cannot connect to sql server. So how should i configure sql in odbc manager. and when i tried to configure it it was giving me the error as quoted in the query. How should i solve it.