reading connection string into a vb application...

[Brad Pears]

I want to have my SQL Server 2000 database connection string data in an .ini
file or a .xml file and then read that string into my vb.net 2005 app -
rather than hard code the connection string in the app.

What are most programmers doing and how do I read this data into my program
on startup?

Thanks! Brad

 

[Terry Olsen]

I use an INI file and read it in. I encrypt it though to keep prying eyes
out. Don't want just anyone seeing how to access your database.

 

[sloan]

VS2005 (2.0) has a complete methodology for using connection strings.

I would not suggest reinventing it.

http://www.google.com/search?hl=en&q=VS2005+"connectionstrings"+web.config

http://www.arcware.net/archive/2005/01/01/1056.aspx

 

[Brad Pears]

Isn't the web.config file only used in asp applications though?? I am using
vb.net 2005.

Thanks, Brad