Blue Prism Product

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

Hi @Atyant Srivastava 
 

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

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

@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,

Hi @Atyant Srivastava 
 

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

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

@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,

Hi @Atyant Srivastava 
 

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

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

Hi,
Sorry,I could not find the Oracle connector in the DX . Please help me.

Thanks & Regards,
Srikanth K

@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,

Hi @Atyant Srivastava 
 

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

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

Hi @Eric Wilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

@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,

Hi @Eric Wilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.