Starting an SQL Server Application

[George1111]

Just wondering what methodology most people use when starting up a SQL Server App.

Eg, Where do you store the SQL Server Name, Database Name, Database User Name, and Password (or the fact it is Windows Authenticated)

I came to the conclusion that an INI file or equivalent would be best, with Encryption on User Passwords (if they exist).

I have had problems when storing this type of info in the registry, particularly when you need to run a variety of Databases for support and demonstration purposes (always needing to change the registry to get something to work)

What do you all do please ?

[dee-u]

INI file here assuming it is VB6.0.

[George1111]

I use VB6 and VB.Net - either way - an INI file to me is just a Text File with the file type INI

I actually store my variables with XML tags

[erickwidya]

now the trend is move from desktop to Web app..web.config is the right file for this

right now i'm using .ini file too and it's great

[TheCPUWizard]

To a large degree it depends on the language, and the intent.

Classig choices are:

a) INI file
b) Registry Setting

More "Modern" Choices:

c) Plain XML configuration file
d) Secure Encrpyted XML Config File

[dee-u]

If you have time you could take a look at this.

[George1111]

Thanks guys - most appreciated