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
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