This is the same way I handle my connection strings except I usually add the
ASPNET account into my SQL server and use Windows authentication so I don't
have to store my password.

I've also seen methods where you store the information in the registry.

I've also seen methods
"Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
news:erFyzOLMDHA.212@TK2MSFTNGP10.phx.gbl...
> The way most developers handle it is to put the connection string in your
> web.config file, like this:
> <configuration>
> <appSettings>
> <add key="DSN" value="Server=(local);Database=DBName;UID=sa;PWD="/>
> <add key="OtherConnectionString"
> value="Server=(local);Database=DBName2;UID=sa;PWD= "/>
> </appSettings>
> </configuration>
>
> Then in your code you can get the connection string like this:
> Dim sConn As String = ConfigurationSettings.AppSettings("DSN")
>
> This is a nice way to manage it. You can change the connection string
> easily without rebuilding the app or restarting IIS or anything, and the
> change goes into effect immediately.
>
> You also might want to combine this technique with a trusted connection so
> you don't have to store your user id and password in the connection string
> on your web server, which you may or may not consider to be a safe place
for
> such data.
>
> You can store other values in your web.config in the same way, and they'll
> be available globally.
>
> --
> I hope this helps,
> Steve C. Orr, MCSD
> [url]http://Steve.Orr.net[/url]
>
>
> "Fadoyo" <fadoyo@hotmail.com> wrote in message
> news:ey46lLLMDHA.2308@TK2MSFTNGP11.phx.gbl...
> > Hi all, I want to build a web application wich connects to a sql Server
> DB,
> > the question is that I want the application to connect with several data
> > bases, and I also want that different users could run it at once and
each
> > one connected with its own db. How could I do this? How could I store
the
> > conection string of each user?
> >
> > Thanks
> > Fadoyo
> >
> >
>
>