473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Exception thrown while accessing Oracle through oracle client

Neo
Hi Everyone
I am trying to acces Oracle using oracle client classes
provided by .net in an asp .net application. But I keep on getting following
error
"System.Data.OracleClient requires Oracle client software version 8.1.7 "

All the solutions mentioned to this problem on various newsgroups indicate a
setting in security permission. I have given all sorts of permission to the
oracle and ora92 folder including everyone-full control. But it is still not
working. But if I try to access it through an exe I don't get that error.
Can anyone please help me?

Thanks
Neo
Nov 19 '05 #1
2 1969
I ran into this one and got through it, but do not remember the specifics of
how. If I remember correctly, it was installing the complete client suite
that solved the issue (the Oracle client tools require a partial, not
complete, install, to work so the fact Oracle tools are working does not mean
OracleClient will). I do not remember a security issue, but that does not
mean it is not the case with your connection issue.

In general, I suggest using ODP.NET (free download from otn.oracle.com) over
the Microsoft OracleClient classes. They are better tuned for Oracle needs.

NOTE: The OracleClient classes will not work againt 10g, as the Oracle
internals have changed.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Neo" wrote:
Hi Everyone
I am trying to acces Oracle using oracle client classes
provided by .net in an asp .net application. But I keep on getting following
error
"System.Data.OracleClient requires Oracle client software version 8.1.7 "

All the solutions mentioned to this problem on various newsgroups indicate a
setting in security permission. I have given all sorts of permission to the
oracle and ora92 folder including everyone-full control. But it is still not
working. But if I try to access it through an exe I don't get that error.
Can anyone please help me?

Thanks
Neo

Nov 19 '05 #2
Make sure that ASPNET, IUSR and IWAM for your machine all have access to the
Oracle folder. They don't need full access. Then do a reset on all child
item permissions.

Then, reboot your computer.
--
Direct Email: Michael.Baltic@RemoveCharactersUpTo#NCMC.Com

Staff Consultant II
Enterprise Web Services
Cardinal Solutions Group
"Neo" wrote:
Hi Everyone
I am trying to acces Oracle using oracle client classes
provided by .net in an asp .net application. But I keep on getting following
error
"System.Data.OracleClient requires Oracle client software version 8.1.7 "

All the solutions mentioned to this problem on various newsgroups indicate a
setting in security permission. I have given all sorts of permission to the
oracle and ora92 folder including everyone-full control. But it is still not
working. But if I try to access it through an exe I don't get that error.
Can anyone please help me?

Thanks
Neo

Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Barry Mossman | last post by:
Hi, I am throwing an exception derived from ApplicationException as follows catch (Exception ex) { throw new MyException("message", ex); } My exception's constructor is: public...
2
by: dan | last post by:
hi ng. i have a asp.net application which is client of an asp.net webservice. now i want to configure a custom error page (in case the sewrvice throws an exception) that provides the...
5
by: Simon Tamman {Uchiha Jax} | last post by:
Now this is bugging me. I just released software for a client and they have reported an unhandled stack overflow exception. My first concern is that the entirity of the UI and any threaded...
6
by: mangesh | last post by:
1 - How to cach invalid memory access exception ? Does standard library provide any help ? 2 - Also when one write catch(...) { //........... } what is wirtten inside catch block . How do...
1
by: yancheng.cheok | last post by:
Hi all, According to "How can I handle a constructor that fails?" in http://www.parashift.com/c++-faq-lite/exceptions.html#faq-17.2, whenever there is a constructor fail, we will throw...
2
by: Mark Brown | last post by:
I'm trying to access an Oracle database vb.net. I found several examples. I tried following each one, but I get the same error no matter what I try. I don't really understand what the error means...
2
by: koredump | last post by:
Hi all, I have a windows app that makes some asyc calls to my webservice (WSE 3.0 with MTOM). exception gets thrown in the client win app. This exception is being thrown on another thread by a...
0
by: Pieter | last post by:
Hi, When using clickOnce for a VB.NET 2.0 application it installs fine on every computer, except one (a new one...). Every is isstalled, Framework, Mdac, .... The error in the log file is:...
2
by: Monty | last post by:
I have a GridView in an update panel, and the GridView has an ObjectDataSource. Under certain conditions the Object that is the ObjectDataSource will throw an exception with a specific error...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.