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.
 

Schenz

Well-known member
Joined
Sep 11, 2004
Messages
181
Location
Cincinnati, OH
Programming Experience
5-10
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.
 

khan_zahid

Member
Joined
Feb 23, 2005
Messages
10
Programming Experience
1-3
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.
 

Schenz

Well-known member
Joined
Sep 11, 2004
Messages
181
Location
Cincinnati, OH
Programming Experience
5-10

malitice

Active member
Joined
Feb 20, 2005
Messages
41
Programming Experience
1-3
You could also store the values in the registry, and allow the client to set up or change the details when they need to.
 
Top Bottom