You didn't answer his question. He knows he needs an ODBC driver and wants to know how to install it on an I.R.
How to Install a ODBC driver on the Azure Integration Runtime machine?
The following link states that a prerequisite for copying data sources using Azure Data Factory is to install an ODBC driver in the Azure Runtime Environment.
https://learn.microsoft.com/en-us/azure/data-factory/connector-odbc
However, I can't find anything that documents how to do this. I would expect that many, many people have either done this or need this information. Please help! I'm stuck
2 answers
Sort by: Most helpful
-
-
Saurabh Sharma 23,826 Reputation points Microsoft Employee
2020-12-01T00:05:56.743+00:00 @Frank Admin Thanks for using Microsoft Q&A.
Which data source you want to connect to using ODBC ? In order to connect using ODBC you need to install specific ODBC drivers on your machine. ODBC drivers are different for different sources so if you would like to connect to a SQL Server using ODBC you need to install ODBC driver(64-bit) and if you want to connect to Microsoft Access source then you need to install ODBC driver for Microsoft Access. Also, you can find installed ODBC drivers in your system by going to Administrative Tools > Data Sources (ODBC).Reference: