Click here to Skip to main content
14,920,295 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi friends
i want my C# windows application to connect a sql server which is hosted in online site
My Connection String:
C#
<add name="Connection" providerName="System.Data.SqlClient" connectionString="Data Source=media.in,8003; Network Library=DBMSSOCN; User ID=UserName; Password=Password; timeout=500;"/>


when executing this query the following error is shown

SQL
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Posted
Comments
Abhishek Pant 19-Dec-12 2:37am
   
timeout=500 really 500 miliseconds?
Kuthuparakkal 19-Dec-12 4:32am
   
Wasit working before ? Are you sure the SQL server media.in,8003 is configued to allow remote connections ?

1 solution

You may be disabling pooling or opening more connections that you realise. Have a look at
http://support.microsoft.com/?kbid=271128[^]
and
http://support.microsoft.com/?kbid=328476[^]

or it could be the way you're connecting ... have a look at
http://bytes.com/topic/asp-classic/answers/125951-connection-string-network-library[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900