Oracle.DataAccess.Client.OracleException
The provider is not compatible with the version of Oracle client
at Oracle.DataAccess.Client.OracleInit.Initialize()
The program runs fine on my development box. The VB.Net application throws the error when the Oracle Connection object is created on the
client machine:
conDB = New oracle.DataAccess.Client.OracleConnection(oradb)
Development:
Windows XP Pro SP1
Visual Studio 2003
Oracle Data Provider for .NET 10.2.0.2.20
Client:
Windows XP Pro SP1
Oracle Database 10g Client Release 2 (10.2.0.1.0)
This thread (
408066 ) has some information on the issue but no real solutions. As it is I took their advice and checked my Registry to ensure the value of DLLPath. It is set to C:\oracle\product\10.2.0\client_1\bin which is correct.
Anyway, I noticed that I'm using ODP 10.2.0.2.20 and the client has Oracle 10g Client 10.2.0.1.0. These are both the latest releases as there is no 10.2.0.2.20 of Oracle 10g Client for Win 32. Is that a reason to be concerned? Also, my Oracle.DataAccess.DLL shows version 1.102.2.20 while the version installed by the 10g Client on the client PC is 10.2.0.100. Could that be an issue?
The client can connect to the database when using SQL+ and there are no other Oracle components installed on that system.
user551594 could sure use some sagely advice!
Thanks.