Click here to Skip to main content
15,444,490 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[^]
 
Share this answer
 

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