Connecting to non Master DB via ODBC

Question

Hi, I've succesfully set up an ODBC connection to my new Azure DB.  Using SSMS i can query Master only (I know a fix is forthcoming for this, perhaps you can let me know of status). Using the DOS cmdline I can query both master and my new DB. In Excel i can also query master only? When I set up the ODBC connection i was only able to select master.  This is set up with native client 10.  When I select my own user DB and test the source connection I get - Microsoft][SQL Server Native Client 10.0][SQL Server]Reference to database and/or server name in 'master.dbo.syscharsets' is not
supported in this version of SQL Server ??  Here's the ODBC settings before testing it.  Can you pls let me know how i can connect to my used DB, not just master.  Thanks v much

Microsoft SQL Server Native Client Version 10.00.2531

Data Source Name: Azure
Data Source Description: Azure
Server: xxxxxxxxxx.database.windows.net
Use Integrated Security: No
Database: Secret
Language: (Default)
Data Encryption: No
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Mirror Server:
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes

Answer 1

I believe the problem is that in order to do "character translation", Excel needs to query the "master" database, but you are connected to a user database "Secret". In SQL Azure you can't do cross database queries, therefore this fails.

In order to solve this, when you are building you ODBC data source, there is one checkbox that is marked by default, please un-check it.
It is called "Perform translation for character data" make sure is not check.

At the end this should change:
Translate Character Data: No

Thank you and I hope this help you,
Alejandro Hernandez.

Answer 2

Hi, thanks but that didn't do it.  Whether I use secret or master and whether i remove that option or not I get the same issue as above.  Whatever I do I cannot query the secret database via excel???
thanks

Answer 3

Actually i have it worknig now! Althuogh it gives this message when testing the source it still aloows connection. I can now see secret via excel.

thanks, Si