ODBC Connection String

iaw

New member
Joined
Jul 6, 2010
Messages
3
Programming Experience
Beginner
Hi,

I've read a few of the other articles on connection strings and I'm not getting anywhere with my issue (I'm still newbie so please forgive me).

I'm looking to connect to a database using an ODBC connection string, the issue is there are multiple database and I'd prefer not to set the default database in the ODBC data source since it can vary depending on certain criteria.

I'd expect it to be something like:

"DSN=Test;UID=Me;PWD=Password;DATABASE=DB1"

Is this correct? Is there an article that lists all the ODBC connection options?

VS2010
 
Back
Top