Professional Web Applications Themes

Specified driver could not be loaded due to system error 126 - ASP

I am trying to connect to an Oracle db with my ASP page. I have a system DSN which works just fine (I can use it to connect to the database through Access). Here is the code I am using: dim objConn set objConn = Server.CreateObject ("ADODB.Connection") objConn.Open "DSN=ORDERS; Uid=ops$briand; Pwd=bd4586" I get the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 126 (Oracle ODBC Driver). /aftweb/daily_punch_list.asp, line 41 Any ideas? Thanks, Brian...

  1. #1

    Default Specified driver could not be loaded due to system error 126

    I am trying to connect to an Oracle db with my ASP page. I
    have a system DSN which works just fine (I can use it to
    connect to the database through Access). Here is the code
    I am using:

    dim objConn
    set objConn = Server.CreateObject ("ADODB.Connection")
    objConn.Open "DSN=ORDERS; Uid=ops$briand; Pwd=bd4586"

    I get the following error:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    Specified driver could not be loaded due to system error
    126 (Oracle ODBC Driver).
    /aftweb/daily_punch_list.asp, line 41

    Any ideas?

    Thanks,
    Brian


    Brian Guest

  2. #2

    Default Re: Specified driver could not be loaded due to system error 126

    "Brian" <anonymousdiscussions.microsoft.com> wrote in message
    news:15f101c3c580$e7b60f60$3101280aphx.gbl...
    > I am trying to connect to an Oracle db with my ASP page. I
    > have a system DSN which works just fine (I can use it to
    > connect to the database through Access). Here is the code
    > I am using:
    >
    > dim objConn
    > set objConn = Server.CreateObject ("ADODB.Connection")
    > objConn.Open "DSN=ORDERS; Uid=ops$briand; Pwd=bd4586"
    >
    > I get the following error:
    >
    > Error Type:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > Specified driver could not be loaded due to system error
    > 126 (Oracle ODBC Driver).
    > /aftweb/daily_punch_list.asp, line 41
    >
    > Any ideas?
    >
    > Thanks,
    > Brian
    "Driver={Microsoft ODBC for
    Oracle};Server=OracleServer.world;Uid=Username;Pwd =asdasd;"

    [url]http://www.connectionstrings.com/[/url]


    McKirahan Guest

  3. #3

    Default Re: Specified driver could not be loaded due to system error 126

    (a) stop using ODBC
    (b) see [url]http://www.aspfaq.com/2126#oracle[/url] for other drivers/connection
    strings for Oracle.

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]




    "Brian" <anonymousdiscussions.microsoft.com> wrote in message
    news:15f101c3c580$e7b60f60$3101280aphx.gbl...
    > I am trying to connect to an Oracle db with my ASP page. I
    > have a system DSN which works just fine (I can use it to
    > connect to the database through Access). Here is the code
    > I am using:
    >
    > dim objConn
    > set objConn = Server.CreateObject ("ADODB.Connection")
    > objConn.Open "DSN=ORDERS; Uid=ops$briand; Pwd=bd4586"
    >
    > I get the following error:
    >
    > Error Type:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > Specified driver could not be loaded due to system error
    > 126 (Oracle ODBC Driver).
    > /aftweb/daily_punch_list.asp, line 41
    >
    > Any ideas?
    >
    > Thanks,
    > Brian
    >
    >

    Aaron Bertrand - MVP Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Specified driver could not be loaded due to system error 31
    By I Need Help! in forum Dreamweaver AppDev
    Replies: 4
    Last Post: February 27th, 10:37 PM
  3. Replies: 1
    Last Post: December 11th, 01:28 PM
  4. Replies: 2
    Last Post: July 24th, 06:17 PM
  5. Replies: 0
    Last Post: June 26th, 10:05 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139