Oct 05, 2016 at 10:57 AM

Problem in connecting from DBCO to Azure MS SQL Server

1008 Views

Hello Experts,

i am trying to access an Azure SQL Service through DBCO. When i test the connection with program "ADBC_TEST_CONNECTION" i get the error:

sql error 40.515 occured:

Reference to database and/or server name in 'master.dbo.syscharsets' is not supported in this version of SQL Server.

In Azure we cant access anything under the master and i cant set the default user db to the one that i want. While i set the mssql_dbname to the database i want to connect in the connection string it seems it ignores it. Here is a sample of the string i use in dbco:

MSSQL_SERVER=XXXXXX.database.windows.net; MSSQL_DBNAME=YYYYY;

I have the latest MS SQL driver installed in SAP Server ( Database Shared Library (DBSL) 7.41 patch 218 & windows Microsoft ODBC
Driver 13 for SQL Server )

Any ideas would be helpfull.