Linked service to Interbase Azure Data Factory

Question

Hi,

I'm trying to establish ODBC linked service connection to Interbase from Azure Data factory and i'm getting below error.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Below is the connection string i'm using:

DRIVER=Firebird/InterBase(r) driver;UID=;PWD=;DBNAME=test:d:/test/test/test.ib;

Answer 1

Hi Velicheti, Satya,

Thank you for posting query in Microsoft Q&A Platform.

The error message you are seeing indicates that the ODBC driver for InterBase is not installed on the machine where you are running Azure Data Factory. To resolve this issue, you need to install the ODBC driver for InterBase on the machine where you are running Azure Data Factory by self hosted IR. You can download the ODBC driver for InterBase from the InterBase website. Once you have downloaded the driver, you need to install it on the machine where you are running Azure Data Factory.

Once you have installed the ODBC driver for InterBase and configured the ODBC data source, you can use the connection string you provided to establish a linked service connection to InterBase from Azure Data Factory.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.