Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Sathish133
Helper I
Helper I

ODBC connection in Data Pipeline or Data Flow Gen2 in Microsoft Fabric

Hi,

 

I am trying to connect the ODBC source in Microsoft Fabric either Data Pipeline (Copy Activity) or Data Flow Gen2.

I have installed the ODBC driver "DataDirect HDP 4.6" in my laptop and created the System DSN with the client specific details like Service Name, port number, Hybrid Data Pipeline Source, user name & password and finally tested the DSN and test is successful.

 

Then I have installed the On-premises data gateway in my laptop and which is showing status as online in Microsoft Fabric.

 

Now I have tried to create the ODBC connection in Microsoft Fabric Data Pipeline Gen2, but which is throghing the error

"An exception occurred: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (Session ID: xxxxxxxxxxxx-xxxx-xxxx-xxxxxxxxxxxxxxxx, Region: us)"


Can you please help, where I am missing something.

 

Below are the screenshots

 

Sathish133_0-1716191542877.png

Sathish133_1-1716191573469.png

Sathish133_2-1716191638336.png

Sathish133_4-1716191841625.png

 

Sathish133_3-1716191755261.png

 

Regards,

Sathish Kumar

1 ACCEPTED SOLUTION
Sathish133
Helper I
Helper I

Hi,

While creating the connection, we should not use {}. After removing {} connection established succesfully.

 

Regards,

Sathish Kumar

View solution in original post

8 REPLIES 8
Yi_Han_Wong
New Member

Hi there - I am also in a similar situation when trying to test my ODBC on an Integration Runtime (I'm using ADF), however it doesn't seem to work in IR.

 

I got the following success message when testing the connection in ODBC Admin:

 

ODBC_success.png

However, when I tried applying the following in IR, I got the following:

IR_error.png

 

Am I missing something here, as I can't seem to get past the error 400?

Below are the steps I followed to connect,

Create the ODBC setup in the machine. On the same machine install the on premise IR and sign in the IR.
Go to ADF and create the linked service with with ODBC name and select the on Premise IR which you created and test the linked service.

Hi Sathish, I managed to set the ODBC set up and the tested it which worked.

I then installed the on-prem IR and tested the IR which is showing the error message I shared earlier.

 

Is there any value of going to ADF to test, if the IR test itself is already failing?

FabricLearner
Regular Visitor

Thank you so much @Sathish133

Your response helped me make an ODBC connection in Fabric. I appreciate your help.

FabricLearner
Regular Visitor

Hi @Sathish133 ,

 

I encountered a similar issue while connecting our Deltek Production database to Fabric using the ODBC connector. Here are the steps I followed:

  • Installed the ODBC driver ‘DataDirect HDP 4.6’ on the SQL server.
  • Created a System DSN (Data Source Name) with client-specific details, including the Service Name, port number, Hybrid Data Pipeline Source, username, and password
  • Successfully tested the DSN.

 

FabricLearner_3-1716396007010.png

 

  • Installed the On-premises data gateway in Sql Server and which is showing status as online in Microsoft Fabric.

 

FabricLearner_2-1716395942659.png

 

  • Now I have tried to create the ODBC connection in Microsoft Fabric Data Flow, but which is throghing below error

    An exception occurred: ODBC: ERROR [HY000] [DataDirect][ODBC Hybrid driver][Hybrid]HTTP library error: Perform failed. (3, The URL was not properly formatted.)

FabricLearner_4-1716396402364.png

 

 

Could you please identify what I'm missing here, and that could be a big help for me.

Thank you and appreciating you help and time.

 

Hi @FabricLearner,

 

In your Fabric Data Flow ODBC connection, Please mention ODBC Connection String as 

 

dsn=Deltek_Fabric_Odbc

 

You have to mention your exact ODBC DSN name in the connection string area and then connect. I hope this will resolve the issue.

 

Note : ODBC Driver, ODBS DSN and On Premise Data Gateway - All should present in the same host.

 

 Regards,

Sathish Kumar

Sathish133
Helper I
Helper I

Hi,

While creating the connection, we should not use {}. After removing {} connection established succesfully.

 

Regards,

Sathish Kumar

Hi @Sathish133 

 

Thanks for using Microsoft Fabric Community.

Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

 

Thank you.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.