rmartes
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nevermind, I got it working. I had an error in my sql. Thanks.
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
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
ASKER
Oracle.DataAccess.Client.O