Custom Export to Oracle Database

Posted by Agung Pambudi in
I'd like to ask how can i extract data to oracle DB ... i tried to export to SQL server before .. and it was succeded but when im trying to export to oracle DB ...its prompting OraOLEDB.Oracle provider is not registered on the local machine. I use oracle 11.2 database... what version of oracle that visual web ripper can extract. Ans I'm guessing that you have not installed the Oracle OleDB provider on the computer where VWR is running. Please see the following section from the manual. Exporting Extracted Data to Oracle: Visual Web Ripper supports Oracle databases only through the Oracle OleDb provider. Oracle client software must be installed in order for the OleDb provider to work. The OleDb provider provided by Microsoft supports Oracle only up to version 8i, so you should use the OleDB provider provided by Oracle. Use an Oracle OleDb connection string such as this one: Provider=OraOLEDB.Oracle;Data Source=//localhost:1521/OracleTest;User Id=test;Password=test; The Data Source parameter in the connection string can be set to a TNS, but only if you have configured the TNS configuration file properly. VWR should be able to connect to Oracle 11.2. If the error message says that "OraOLEDB.Oracle provider is not registered on the local machine", then please make sure that this provider is in fact installed. Maybe this link will help you: https://community.oracle.com/thread/2367179

Please you make sure that you installed Oracle client software in order for the Oledb provider to work. and you should install 32bit Oracle client software since VWR was built in for 32bit platform.

No comments:

Post a Comment