ODBC Linked Server in Managed Instance

Copper Contributor

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
Hi

Did you find the solution to your issue? I am trying the same.

Thanks
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