Connection String - connection not working

[girish.kardam]

Hi,

I am hvg application developed in VB.Net 2005 previously it was on running on single pc and using local database. But now i want o install the same application on multiple pcs and want to centralize the database to avoid duplicacy. I am using this connection string
"Dim sqlcon As New SqlConnection("uid=sa;pwd=sa;Server=\\10.52.4.10;database=dainik")" for connecting to remote database. But its not working, while when i registering the same system database in sql server it is working properly. Kindly guide me.

 

[pachjo]

whenever I need a connection string I connect to the server from within the VS.NET IDE and then look at the connection string property.....

works for me everytime

 

[naveentp]

This should work I guess, I have removed the "\\" in the servername.

Dim sqlcon As New SqlConnection("uid=sa;pwd=sa;Server=10.52.4.10;database=dainik")