Find Me On Facebook

Quote

Labels

About me

I am a Computer Programmer. I create software to help people and improve their quality of life. Make software that people can easier to use. Make people much happy and love with the software. I love to learn and work, individually and teams.
I am still fool enough, but I am willing to learn and develop new skills and I am also a very hard worker and happy to undertake any training to achieve career success.

Custom Export to Oracle Database

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.