brencin
04-16-2006, 05:33 AM
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!
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!