asked on

Win Server 2k8 R2 / Oracle Client 10g / ODAC

Hi Guys,

I have a Windows Server 2008 R2 and an ASP.NET application that needs to connect to an Oracle 10g 64-bit Database (hosted on another server) using an ODBC connection.

I have installed Oracle 10g Client (10.1) and have successfully connected to the database using SQL Plus.

I have tried to install the driver for the data source (ODAC 10.1), but I am getting "Abnormal program terminiation...unknown. unknown. unknown....

I decided to give 11g R2 a try. I was able to install both the client (11.2) and ODAC (11.2), but I don't see the ODBC driver listed when I attempt to create a data source.

Any suggestions?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rmartes

ASKER

Thank you so much for the help slightwv. I decided to give ODP.NET a try. I placed Oracle.DataAccess.dll into my app's bin folder and slightly modified the connection string. However I get the following error when executing OracleDataReader = dbCommand.ExecuteReader():

Oracle.DataAccess.Client.OracleException: ORA-24333: zero iteration count

rmartes

ASKER

Nevermind, I got it working. I had an error in my sql. Thanks.

slightwv (䄆 Netminder)

Glad to help.

One final thing as you move forward: When you go to deploy the app you must have the exact same ODP.Net version on the host machine that was used to compile the app.

There is a work-around where you can force versions using the app.config in this question:
https://www.experts-exchange.com/questions/27020817/The-provider-is-not-compatible-with-the-version-of-Oracle-client.html?anchorAnswerId=35709210#a35709210

There is also a work-around where you can copy 5 Oracle DLLs and not worry about an install at all:
https://www.experts-exchange.com/questions/23861097/How-to-configure-ODP-NET-XCOPY-installation-on-client-machine.html