Solved

How do I connect to an oracle db in my ASP .NET web application, and what do I need to make this work?

Posted on 2013-01-18
8
263 Views
Last Modified: 2013-01-24
This is my first time connecting to an Oracle DB in a web application. What all do I need to make this work? Which using statement do I need? Do I need to add a reference to my Bin folder? If so which one? Are there any clear examples of this (links to them)? Where can I find / download the Oracle Client for .NET?
0
Comment
Question by:mikesExpertExchange
  • 4
  • 2
  • 2
8 Comments
 
LVL 20

Accepted Solution

by:
informaniac earned 500 total points
ID: 38793763
0
 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 38794074
@infomaniac: thank you. I downloaded that and wrote some code. all is well with the exception of me getting this error message:

{System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.}

when I attempt to open my connection. how do I upgrade to the correct version? Or, where do I go to get the download that contains the correct version?
0
 
LVL 9

Expert Comment

by:sognoct
ID: 38794274
you have to install the oracle client, the installer is inside ODTwithODAC112030.zip that informaniac linked
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 38794296
@sognoct: ok. I'm having trouble with being for certain which file that is within the zip. i think that's what I need help locating / specifying. I followed the instrctions in the read me html file and opened a command line and did:

install.bat all c:\oracle oda

i thought that would do it. no?
0
 
LVL 20

Expert Comment

by:informaniac
ID: 38794298
0
 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 38794312
@informaniace: in the statment below, where do I find this at? (this being: "the reference to the ODP.NET).

"In the reference to the ODP.Net make sure "require specific version" = False.  You may also want to set Copy Local to True.  If you aren't using ODP.Net then you may want to look into doing that."

Also how do (or where do) i check which version of Oracle Client I'm running? Sorry about the "newbie" questions but i am new to this.
.
0
 
LVL 9

Expert Comment

by:sognoct
ID: 38794323
I used ODTwithODAC112030.zip

in :
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

and there is
ODTwithODAC112030.zip

this contains a working
setup.exe run it as administrator and will work

for the new version, I've not installed yet ...
0
 
LVL 1

Author Closing Comment

by:mikesExpertExchange
ID: 38815648
thank you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now