Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: Database problems

    I'm running a news ASP script on my server and I keep getting this error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Specified driver could not be loaded due to system error 126 (Microsoft Access Driver (*.mdb)).

    /news/Admin.asp, line 87


    The code uses Microsoft Jet OLE Provider, and in the past i've only been able to use things with a DBQ= But another provider might work just as well.

    As far as I know, it's a Microsoft ISS cold fusion server, but ASP has worked on it before so I know it's installed. I'm just having trouble with it finding the driver as in the error snippet above.

    Dim adoCon
    Dim strCon

    Set adoCon = Server.CreateObject("ADODB.Connection")
    strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("SpawnedDB_nw_db.mdb")
    adoCon.Open strCon


    thats where I bomb out.

    thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    check an make sure the latest version of the driver is installed...if it isn't then update it.

    otherwise try uninstalling the driver and then reinstalling.

Posting Permissions

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