How to mantain sql connection

[khan_zahid]

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]

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]

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]

Ok, I would recommend you use either app.config or web.config (depending on the app type) to store your connection string.

Here are a couple of places to get more info on this.

This way you are not hard coding connection string information (and can change it in the future without having to recompile)

There can be security issues because a config file is simply an XML file.

http://www.code101.com/Code101/DisplayArticle.aspx?cid=3
http://www.vbcity.com/forums/topic.asp?tid=76123

 

[malitice]

You could also store the values in the registry, and allow the client to set up or change the details when they need to.