Reputation: 43
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.
Upvotes: 2
Views: 1051