topic How to get dll path from the PB's original VBO in Product Forum

How to get dll path from the PB's original VBO

hantao — Mon, 16 Dec 2024 01:23:48 GMT

I wang to get the dll file that in the VBO OLEDB(System.Data.dll) ,but it only show the dll name in the Extenrnal References
window,i cant know the currect directory,how can i get the file?

Re: How to get dll path from the PB's original VBO

Nandhakumar — Mon, 16 Dec 2024 02:30:11 GMT

Hi @hantao ,

you should be able to find the dll's under this directory in you machine.

C:\Windows\Microsoft.NET\Framework\v4.0.30319 (Considering the .NET framework is v4)

Thanks,

Nandha

Re: How to get dll path from the PB's original VBO

hantao — Mon, 16 Dec 2024 02:57:46 GMT

Hi @Nandhakumar

thanks friend,I know that dll,i just want to make sure that dll you said weather is the on BP used.Beacause ,i used the dll and used the same code from the VBO(OLEDB) for connecting Oracle,bug it didn't work.

error as following:

The data source ‘OraOLEDB.Oracle’ provider is not registered on the local computer. Unable to connect to

so i thank maby the version of the dll is not the same as BP used.

can you gei me more suggestion? thanks again.

Re: How to get dll path from the PB's original VBO

Nandhakumar — Mon, 16 Dec 2024 03:29:57 GMT

Hi @hantao

Can you check the below first and try again, if issue still persists please let me know.

1. Verify that ODAC(Oracle Data Access Component) Driver is installed on your machine

2. Check it is 32 or 64 bit should same as Blue prism

Also please make sure the connection string you are using is correct for Oracle db

Thanks,

Nandha

Re: How to get dll path from the PB's original VBO

hantao — Mon, 16 Dec 2024 04:53:42 GMT

Hi @Nandhakumar

It is true that I do not have ODBC driver installed on my computer, however, my question is the same code, why BP can use System.Data.dll to operate the database, but I use it will report an error, the difference is only in the referenced dll file, my guess is right?

My computer is 32 bit.

Hope you answer.

Re: How to get dll path from the PB's original VBO

hantao — Mon, 16 Dec 2024 04:54:28 GMT

Hi @Nandhakumar

Sorry it is wrong, My pc is 64 bit.

Re: How to get dll path from the PB's original VBO

Nandhakumar — Mon, 16 Dec 2024 06:08:51 GMT

Hi @hantao ,

i have found the below thread in the community, please go through this, it might help.

OraOLEDB.Oracle' provider is not registered on the... - SS&C Blue Prism Community

Thanks,

Nandha

Re: How to get dll path from the PB's original VBO

hantao — Mon, 16 Dec 2024 07:18:43 GMT

i saw the issue ,it means that i need to install Oracle oledb Provider , it maby be useful, i will try it.

And i still want to know why the VBO can be ran successfully by BP,but without BP,i have to install Oracle oledb Provider.