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

[hantao]

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?

[Nandhakumar]

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

[hantao]

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.

[Nandhakumar]

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

[hantao]

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.

[hantao]

Hi @Nandhakumar 

Sorry it is wrong, My pc is 64 bit.

[Nandhakumar]

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

[hantao]

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.