Forum Discussion
ODBC Linked Server in Managed Instance
Hi, Peoples
I have a Managed Instance that I access via a VM created on Azure. On this same machine I installed the database ODBC driver and registered the connection in ODBC Data Sources. In SQL in Linked Servers I created the connection, but I can't find the data source.
3 Replies
- What is the target of the Linked Server in managed Instance? ODBC should be able to connect to managed instance, so I am not sure the question is very clear as to what you are trying to do.
ODBC --> ManagedInstance
TSQL --> SELECT * From LINKEDSERVER.Database.dbo.Table
Not ODBC --> LinkedServer - Hi
Did you find the solution to your issue? I am trying the same.
Thanksaccording to following documentation, Linked Server doesn't support ODBC
T-SQL differences between SQL Server & Azure SQL Managed Instance - Azure SQL Managed Instance | Microsoft Docs
