• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2182
  • Last Modified:

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?
0
rmartes
Asked:
rmartes
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>I was able to install both the client (11.2) and ODAC (11.2),

No need to install both.  One or the other would work.  Also for ODBC you can use the Instant Client.

Did you install the ODBC drivers?  I don't think the regular client installs them by default and I think ODBC is an option on the ODAC install as well.

You also need the same Bit version the .Net app is compiled for.  I would suggest you not compile it for AnyCPU.  This has caused some problems when looking for Oracle drivers.

I doubt you can change it now but I would strongly suggest you use ODP.Net to connect a .Net app to Oracle not ODBC.
0
 
rmartesAuthor Commented:
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
0
 
rmartesAuthor Commented:
Nevermind, I got it working. I had an error in my sql. Thanks.
0
 
slightwv (䄆 Netminder) Commented:
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:
http://www.experts-exchange.com/Database/Oracle/Q_27020817.html#a35709210

There is also a work-around where you can copy 5 Oracle DLLs and not worry about an install at all:
http://www.experts-exchange.com/Database/Oracle/Q_23861097.html
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now