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