It is my first integration for our CMS to use an Oracle database. I downloaded and installed the 11g database on my development PC
(XP) and have had luck getting the site running.
I am having problems connecting to my development machine running the database
once I depoloy my ASP.NET website to a staging server (2003 Server) that does not have the oracle database installed. The staging server is
still w/n our LAN and I can ping each 192.168.1.n machine so there is not a firewall issue.
Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client
Stack Trace:
[OracleException (0x80004005): The provider is not compatible with the version of Oracle client]
Oracle.DataAccess.Client.OracleInit.Initialize() +401
Oracle.DataAccess.Client.OracleConnection..cctor() +767
[TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.]
Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString) +0
Common.LogError(Exception ex) in C:\Inetpub\wwwroot\xxx\dev\App_Code\Common.vb:81
ASP.global_asax.Application_Error(Object sender, EventArgs e) in C:\Inetpub\wwwroot\xxx\dev\global.asax:16
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.HttpApplication.RaiseOnError() +135
Oracle.DataAccess.dll
Version: 2.111.7.20
web.config
<add name="WebsiteDB"
connectionString="Data Source=opdesign0807.xxxx.com:1521/orcl;
User ID=xxxxxxxxxx;
Password=xxxxxxxxxxx"
providerName="System.Data.OracleClient"/>
In the hours spent reviewing this excellent forum, I have not found what is causing this connectivity issue. I'm thinking perhaps
the developer version I donwloaded from Orcacle only allows local client connections, and that I must install the Oracle database on
my staging server.