ODBC Connections issue.

[abhi2636]

Hi experts,

Can anyone please let me know how to give ODBC connections to work on Remote server. Iam working on Remote server, The job got executed successfully but I couldnot see the result in the target. When I view the target, the following error is being shown,

"ODBC call <SQLDriverConnect> for data source <IMPERIO> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>. Notify Customer Support."

Is there any ODBC connections need to give. Please let me know how to solve this issue.

Thanks,

Abhi.

[Former Member · Accepted solution]

Hi,

Do you have the same ODBC connection to the target database created on the client?

Nawfal

[abhi2636 · Accepted solution]

Hi Nawfal ,

Thanks for your reply.

I am new to ODBC connections. I don't know how to configure them. Can you please give a detailed idea about this connections.

Thanks in advance,

Abhi

[Former Member · Accepted solution]

Hi Abhi,

If you have access to the server, go to Windows, Control Panel\System and Security\Administrative Tools\Data Sources (ODBC) and in the User or System DSN tab look for your database connection that you used in your datastore. In your Windows client you should have similar ODBC DSN as in the server, so add a new configuration with exact driver and connectivity details. If on your DS client designer you don't find the database driver like in your server that  it would mean  you need to install the database client driver.

Please let me if you have any question.

Nawfal