'How to create an ODBC connection to specific database name
I'm trying to create an ODBC connection on a Windows 10 PC, for use with Excel, to an Azure SQL database. The problem is we don't have permissions to connect to the master db (we don't own the Azure space or server), only our specific database. When following the ODBC create connection wizard, there is no chance to specify the target database, therefore the connection attempt fails with Unauthorized. When using SSMS, the connection dialog has an Options tab that allows you to specify the database you are connecting to.
How can I specify the database, or catalog, in the connection info for a new ODBC connection or DSN? I've tried including it in the db server field, like myserver;mydatabase or myserver/mydatabase with no luck.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|