Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Thumbs up Unanswered: Problem: Connecting to Oracle via ASP.NET, runtime error.

    Hello,

    My co worker is having a problem connecting to an Oracle DB through an ASP.NET application. He's installed the Oracle 9i client on his machine, but ASP.NET insists that it's NOT installed (via a runtime error).

    He's gone through the trouble shooting on MSDN, but nothing's working.
    He made sure the Oracle OLEDB/ODBC drivers were installed.

    Thanks for any help that you may provide,
    ELmO

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Can you connect via SQL*Plus to the Oracle DB?
    Unless & until this works you have ZERO assurance that the Oracle client is properly configured.
    I suspect that the Oracle client s/w will NOT talk to the DB on the 1st attempt.

    First make things work, then make them fancy.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2004
    Posts
    3
    My coworker said SQL Plus connection works.

    Thanks for the help - any other solutions?,
    ELmO

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Since the Oracle piece successfully connects to the DB,
    then the problem resides in the Windoze (ASP.NET or possibly OBDC) part of the universe and this is not the best forum to solve this issue.
    Client-->ASP.NET-->ODBC-->PC_Oracle-client-->SQL*Net-->OracleDB
    Since PC_Oracle-client-->SQL*Net-->OracleDB works the problem resides further upstream towards the actual client application.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Posts
    34
    Did you got "Unable to load DLL(oci.dll)" error message?
    If that is the case, You may not have proper permissions set at oracle
    folder that contains oci.dll.

    Give asp.net worker process user (usually ASPNET) these
    permissions on "D:\oracle" folder (apply recursively)

    Hope it helps...

  6. #6
    Join Date
    Jul 2004
    Posts
    3

    Thumbs up Horse's mouth

    From the horse's mouth (yes he really is a horse, mr ed is real):
    "OK, I got it to work; I had to give the ASPNET account full control on the entire Oracle directory tree."

    Thanks,
    ELmO

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •