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?)
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)