- Posts: 15
- Thank you received: 0
Conection Problem Oracle Windows 7
11 years 3 months ago #5233
by unifscm
Conection Problem Oracle Windows 7 was created by unifscm
I am using the Enterprise ETL Processor in Windows 7, version 5.3.1.2.
When I use the Oracle connections, configure and test set, works well. (Attachment 1).
At the time that you want to exchange data, either as a package or as a repository using Oracle gives the following error (Attachment 2).
The same configuration of ETL Installed in Windows XP, it works without problems.
As temporary solution I connect to Oracle via ODBC and everything works fine.
The problem is that I need to use Direct Path Loading to upload the data to Oracle using ODBC and I have no such option, then it takes too long to upload the information.
Thank you for your help.
regards,
Jorge
When I use the Oracle connections, configure and test set, works well. (Attachment 1).
At the time that you want to exchange data, either as a package or as a repository using Oracle gives the following error (Attachment 2).
The same configuration of ETL Installed in Windows XP, it works without problems.
As temporary solution I connect to Oracle via ODBC and everything works fine.
The problem is that I need to use Direct Path Loading to upload the data to Oracle using ODBC and I have no such option, then it takes too long to upload the information.
Thank you for your help.
regards,
Jorge
Attachments:
Please Log in or Create an account to join the conversation.
11 years 3 months ago #5234
by admin
Mike
ETL Architect
Replied by admin on topic Re: Conection Problem Oracle Windows 7
You have to install Oracle Ole db provider from oracle.
(BTW There is a note in the documentation about that)
Also make sure that you patched Oracle client to the latest version related to the database version.
Eg if you work with oracle 10 patch it to the latest version of oracle 10
John
(BTW There is a note in the documentation about that)
Also make sure that you patched Oracle client to the latest version related to the database version.
Eg if you work with oracle 10 patch it to the latest version of oracle 10
John
Mike
ETL Architect
Please Log in or Create an account to join the conversation.