1

In ADF, I have created a pipeline. The source is an ODBC table or query. The next step is to create a Linked Service. The Integration Runtime has been created and selected as you can see below.

Now comes the question: What connection string am I supposed to enter?

Attempts with Server=192.168.1.35; Database=dbname;DSN=IP/port;UID=userId;PWD=password; resulted in ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Azure New linked service (ODBC) page

MeanGreen
  • 3,098
  • 5
  • 37
  • 63

1 Answers1

1

In the below format, fill in the values and test the connection:

DRIVER=Firebird/InterBase(r) driver;UID=[userid];PWD=[password];DBNAME=[IP and optionally /port]:[C:\example\atrium.FDB]

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
MeanGreen
  • 3,098
  • 5
  • 37
  • 63