We are trying to use ODBC enterprise stage to extract data from Oracle databases. I have done changes in dsenv, .odbc.ini and uvodbc.config to configure Oracle database. When i try using ODBC stage, it gives me an error message as below.
##E TOSH 000205 19:10:55(005) <main_program> PATH search failure:
##E TOSH 000000 19:10:55(006) <main_program> Error loading "orchodbc": Could not load "orchodbc": No such file or directory.
##E TOSH 000000 19:10:55(007) <main_program> Could not locate operator definition, wrapper, or Unix command for "odbcread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 19:10:55(008) <main_program> Creation of a step finished with status = FAILED.
Can you please someone share your experience to configure ODBC.
Regards
ODBC Enterprise Stage Configuration
Moderators: chulett, rschirm, roy
Have you read the Reference Guide for the stage? Done things like add the two $APT_ORCHHOME variables where and how it shows? Best to let us know what you've done so people can advise you on what's still left.
And, out of morbid curiousity, why not use the Oracle Enterprise stage?
And, out of morbid curiousity, why not use the Oracle Enterprise stage?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Craig,
Thanks for your response.
There is no branded_odbc in the PXEngine folder, which is the value of APT_ORCHHOME env variable. I have added $DSHOME/branded_odbc in the path env variable and $APT_ORCHHOME/lib & $DSHOME/branded_odbc/lib in the library path env variable.
In ODBC INI, i have added DSN name = Data Direct driver for Oracle and added section to mention the driver path for that DSN.
That DSN added into uvodbc.config file.
Please let me know if anything is missed out.
Regards
Saravanan
Thanks for your response.
There is no branded_odbc in the PXEngine folder, which is the value of APT_ORCHHOME env variable. I have added $DSHOME/branded_odbc in the path env variable and $APT_ORCHHOME/lib & $DSHOME/branded_odbc/lib in the library path env variable.
In ODBC INI, i have added DSN name = Data Direct driver for Oracle and added section to mention the driver path for that DSN.
That DSN added into uvodbc.config file.
Please let me know if anything is missed out.
Regards
Saravanan