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
Vertica Connectivity Issue with Informatica
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Thu Mar 07, 2013 11:45 am
Vertica Connectivity Issue with Informatica
- Attachments
-
- set up routine error.docx
- Set up routine error
- (36.25 KiB) Downloaded 893 times
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica Connectivity Issue with Informatica
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:
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:
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Vertica Connectivity Issue with Informatica
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
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
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica Connectivity Issue with Informatica
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:
3. Re-install the Vertica 6.0.2 32bit drivers
But, first check if you have the MS components installed
Thanks!
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:
3. Re-install the Vertica 6.0.2 32bit drivers
But, first check if you have the MS components installed
Thanks!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.