Data Connections in VS 2005

Hello,

I'm having a problem creating a connection to my MSSQL 2000 Server database (hosted on discountasp) using the Microsoft SQL Server (SqlClient) datasource. After filling in all the fields, I click the Test Connection button and get a "Test Connection Succeeded" message.

However, when I select the OK button to complete the connection, I recevie this error message: "Timeout expired. The timeout period elapsed prior tocompletion of the operation or the server is not responding."

I have no problems making the connection using the Microsoft SQL Server (OLE DB) datasource but I would prefer to use the (SqlClient) datasource.

Any suggestions?

Thanks!

 

It happened to me once


May be it is the settings of your antivirus.. My kaspersky was set to examine any database connection and test all the backets sent or received...and with a slow internet connection it timedout till I reset it not to test the Database...