The Vertica Database Forums

Hi Team,

We installed vertica client install for client system having 32 bit .

We have created ODBC connection through ODBC Administrator.

In Informatica when we try to import the vertica database through the ODBC connection created for vertica ,but the error is appearing as below:

specified driver could not be loaded due to system error 182 vertica
We tried with installing informatica plug in provided by vertica,while executing the workflow session is failed and not displaying any error.

And also i have attached another error occurs as set routine for the vertica ODBC . Please let me know if you need further information about this issue.

Kindly help me to resolve this issue.

Thanks & Regards,

Mani

Hi!

What version of Informatica are you running and which version of Vertica's ODBC driver did you install?

Did you test the ODBC connection from the Admin Tools/ODBC Data Source Admin/Configure screen?



Using your own specific settings, you should see the following message when clicking on the "Test Connection" button:

Hi,

I am also facing the same error while importing data from Vertica in Informatica through odbc connection on 32-bits windows platform..

Specified driver could not be loaded due to system error 182(Vertica, C:\Program Files\Vertica Systems\lib\vertica_6.0_odbc_3.5.dll)

I am using Informatica 9.1.0 and Vertica 6.0.

Kindly help me in this issue.

Thanks & Regards,
Surbhi

Hi!

This is a guess, but I think your issue may be resolved by

1. Uninstall the Vertica 6.0.2 32bit drivers
2. Uninstall the the 32bit (x86) Microsoft Visual C++ 2008 redistributable components from Microsoft available here:

• http://www.microsoft.com/en-us/download ... px?id=5582

3. Re-install the Vertica 6.0.2 32bit drivers

But, first check if you have the MS components installed

Thanks!