How to mantain sql connection

khan_zahid

Member
Joined
Feb 23, 2005
Messages
10
Programming Experience
1-3
Help

How to mantain sql connection in vb.net winform application after deployment.
I tried to search on google but i dint get it.
Can any body help me.
 
One of the advantages of ADO.net is the fact that a connection to SQL Server is not needed to be active at all times. It makes it much more scaleable.

Perhaps you should explain exactly what it is that you are attempting to accomplish.
 
The problem is that

I have developed a small application using vb.net & sql server 2000.
While debuging we write server path like this

Sqlconnectionstring1="Server=localhost;uid=sa;pwd;database="Exampledatabase"

I want to know that how to do coding so that connection string can be handled after deployment. bcoz server name may change. User id and password cannot be same as we write in our coding. It depends upon client.

plz i want help on this.
 
You could also store the values in the registry, and allow the client to set up or change the details when they need to.
 
Back
Top