Are Azure Elastic Database Queries supported?
Hello, i'm trying to access some Azure database using the "com.microsoft.sqlserver.jdbc.SQLServerDriver" MSSQL driver.
I can connect, but when i try to synchronize the DB i get an error: "Reference to database and/or server name in 'XXXX.schemas' is not supported in this version of SQL Server."
The problem seems to be that that DB uses the "Elastic Database Query" feature... is that supported in Datagrip, or any hint how to get that working?
Thanks a lot in advance.
Please sign in to leave a comment.
Hi,
There is an issue that looks similar https://youtrack.jetbrains.com/issue/DBE-3936
Let me know if workaround mentioned there won't help you.
Thank you
Hi Vasily, thanks a lot for your heads up. I just tested with 2017.1.1 and 2017.1.2, but it did not work since the Database it complains about when loading the schemas is exactly the one i need to access. So, if i disable it i get no useful data.
A similar thing happens if i select "Introspect using JDBC metadata" / Except system schemas... no error but no interesting data either.
Thanks for the hints anyways...