Link to home
Start Free TrialLog in
Avatar of AidenA
AidenA

asked on

installed ODP.NET but get error 'oraoledbpus10.dll: the specified module could not be found'

Hi,

I'm trying to get ODP.NET to work but came up with the above error when trying to connect through code (VB.NET). My Connection string is below.

I am connecting to an Oracle 10g database on a server. I downloaded from Oracle: Oracle 10g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET. The version is 10.2.020.

I think one of the problems might be the fact that the default oracle home is currently in the folder E:\oracle\ora92 but the ODP.NET created a new oracle home in E:\oracle\product. So, I saw something on the release notes saying this would cause a problem... but i'm not sure how to fix

Can anyone help me get this working? (humm, i guess the way i'm connecting below won't work anyway either, that's just for a standard oledb connection i guess?)

Thanks, Aiden
strOracleServer = "Provider=OraOLEDB.Oracle;Data Source=ORCL1;User Id=MANUALTASKS;Password=MANUALTASKS; Min Pool Size=10;Connection Lifetime=120;Connection Timeout=120;Incr Pool Size=5;Decr Pool Size=2"

cnnADO = New OleDbConnection(strOracleServer)
cnnADO.Open()

Open in new window

SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check the connection strings for ODP.NET

http://www.connectionstrings.com/oracle#p12
Avatar of AidenA
AidenA

ASKER

yeah have all that actually, accidentally used the wrong connection string... but when i use the correct one, I now get the error

An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB

(also, I have this feeling that the oracle home thing will be an issue even if I get the connection part right?)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>An OLE DB Provider was not specified in the ConnectionString

Check the project's references.  Make sure you are referencing the ODP classes and not the OLEDB ones.
Avatar of AidenA

ASKER

well i have to say i'm surprised but it's working. I was expecting that to be much more painful!