ODBC connection working in IR but not working in ADF using ODBC

Bethamsetty, Sridhar 0 Reputation points
2023-02-15T06:21:46.45+00:00

Hi, ODBC connection in ADF is not working and throwing below exception. I am using Integration Runtime and System DSN that i have defined in IR is working fine and connecting to Databricks location. i am using token which i have generated in databricks workspace. Any help would be greatly appreciated.

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    2023-02-21T22:40:25.81+00:00

    Hello @Bethamsetty, Sridhar,

    Welcome to the MS Q&A platform.

    Can you please check if you use any special characters in the password?

    Ex: Semicolon in the password “;”

    I have seen this error when using a semicolon in the password for the MySQL-linked service. So, I am guessing it could be related to a special character in the password.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.