Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Regards,
Sathish Kumar
Solved! Go to Solution.
Hi,
While creating the connection, we should not use {}. After removing {} connection established succesfully.
Regards,
Sathish Kumar
Thank you so much @Sathish133!
Your response helped me make an ODBC connection in Fabric. I appreciate your help.
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:
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.)
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
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.