Mahendra Dhaker
Mahendra Dhaker

Reputation: 43

Informatica, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error when connecting to Exasol database

I am trying to connect to Exasol database from Informatica where I want to do some read and write operations but getting below error when running the session. I have added driver details in ODBC Data Source Administrator.

Message Code: CMN_1022 Message: Database driver error... CMN_1022 [ [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Database driver error... Function Name : Connect Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [User_Name] and connection string [Connection_String].]

Please let me know if any additional information is required.

Below are screenshot of USER DSN and SYS DSN entries. I tested the connection and showed successful.

User DSN Sys DSN

Upvotes: 2

Views: 1051

Answers (0)

Related Questions