Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: ODBC Driver Error Message

    Hi

    I am using Oracle 8.1.7.4 with IIS 6.0.
    When ever my asp application tries to access the database it comes up with the following error message

    The Error Number is: :
    -2147467259

    The Error Description is:
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    I can connect to the database through sqlplus / sql navigator etc

    Can anyone pls help??

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    A few things to check. First, are you using the Merrant ODBC drivers installed by the Oracle Client software? Second, did you correctly define and test the ODBC datasource defined on the computer where IIS is running? Third, when you test the connection do you see entries appended to the end of listener.log - if not then you're not getting that far and can isolate the problem back to the client setup. The error message I think is a catch-all, and probably has a hundred causes.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Ensure that you have the 8.1.7.4 odbc driver kit. It is a separate download
    from the 8.1.7 distibution. I resolved many problems by pulling that odbc
    download. It's about 1meg in size.

    HTH
    Gregg

Posting Permissions

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