22-05-23 12:52 PM
I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with database.
22-05-23 04:28 PM
@Kummari Srikanth
How are you attempting to connect to the Oracle instance? What VBO are you using?
Cheers,
22-05-23 06:03 PM
Hi @ewilson
I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.
Thanks & Regards,
Srikanth K
22-05-23 06:14 PM
@Kummari Srikanth
You won't be able to connect to Oracle using the SQL Server VBO. Two completely different database systems. You should be able to use the OLEDB VBO, but you have to have Oracles OLEDB provider installed on the machine you're testing from and you have to reference it in your connection string.
FWIW - There is an Oracle DB VBO available on the DX. You can find it at the following link:
https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility
Review the user guide and make sure you install the necessary prerequisites if you want to try it.
Cheers,
23-05-23 06:32 AM
Hi @ewilson
How to install OLEDB Provider on the machine.Please kindly guide me on this.
Thanks & regards,
Srikanth K
23-05-23 01:54 PM
Download accessdatabaseengine 64 bit open command prompt and run the below query and restart blue prism and try
C:\your_path_where_exe_is_saved \AccessDatabaseEngine.exe /quiet
24-05-23 06:49 AM
Hi,
Please mention the provider name that should be given in the arguments of the Set Connection Action.
Regards & Thanks,
Srikanth K
25-05-23 06:16 AM
Downloaded accessdatabaseengine 64 bit opened command prompt and runned the below query and restarted blue prism...
C:\your_path_where_exe_is_saved \AccessDatabaseEngine.exe /quiet
Still getting same error :OraOLEDB provider is not registered on the local machine.
Please help me on this issue.
Regards & Thanks,
Srikanth K
25-05-23 03:53 PM
@Kummari Srikanth
The Access Database Engine redistributable is for working with Microsoft Access database instances. You mentioned an Oracle error which implies you're trying to connect to an Oracle database. You can use OLEDB for that, but you must have the Oracle OLEDB provider installed and included in your connection string. Alternatively, there is the Oracle connector on the DX which I referenced previously in this thread. If you want to make use of that connector, you need to read the user guide. There's a prerequisites section that points you to the files you need and where they need to go:
Cheers,
26-05-23 05:59 AM
I agree with Eric, I misinterpreted the question, you need to install Oracle oledb Provider installed and include in your connection string