in reply to Specifying Database in DSN string of DBI:ODBC
It is possible. You can use 'dbi:ODBC:xxxx' and all xxxx will be passed to SQLDriverConnect and hence you can use connection strings like 'dbi:ODBC:driver={mydriver};database=mydatabase;uid=me;pwd=mypassword'. It just depends what ODBC connection attributes your ODBC driver supports. I believe MS SQL Server supports 'database' but you can also specify the database in any DSN you create via the ODBC Administrator.
|
|---|