Microsoft OLE DB Provider for ODBC Drivers (0x80004005) ERROR

Posted on 2006-04-26
Last Modified: 2007-12-19
I am trying to use ASP to Access an Access 2003 database
I am using windows XP profesional with IIS installed the error is

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's
found and no default driver specified

I have tried different ODBC drivers but which one should i use to get it working?

Could someone explain to me step by step what to do thanks.
Question by:mtips
    LVL 5

    Accepted Solution

    You can use the connection string to open the connection with access2003

    Dim oCN
    Dim strCon

    strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Projects\VirtualDirs\DS_App\Db\DS.mdb;Persist Security Info=False"

    Set oCN = Server.CreateObject("ADODB.Connection")

    oCN.Open strCon

    Note :
    "Data Source=D:\Projects\VirtualDirs\DS_App\Db\DS.mdb" This should be the physical path where the MDB file is stored. You need to check your file path
    LVL 20

    Expert Comment

    what is your connection string to connect Access DB ?
    post it here so we can find the problem
    LVL 20

    Assisted Solution

    try this one :

          strDB = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=;"
          strDB = strDB & "DBQ=C:/path/db/Access.mdb"

    save this file as con.asp

    and now u call the file:
    <!--#include file="con.asp" -->
    Dim strDB, objRs, objCon, strSQL
    Set objCon = Server.CreateObject ("ADODB.Connection")
    objCon.Open strDB
    strSQL= "SELECT * FROM AccessTbl"
    Set objRs = Server.CreateObject ("ADODB.Recordset")
    objRs.Open strSQL, objCon,1,3

    and so on......


    Assisted Solution

    Try this

    Set conn = Server.CreateObject ("ADODB.Connection")
    conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/filename.mdb")
    LVL 8

    Assisted Solution

    by:Leo Eikelman
    The following microsoft doc lists the most common solutions to this problem:

    It could stem from not having permissions to use the dirvers.

    Using an ODBC DSN

    Insufficient Permissions to Read the DSN Registry Key
    Grant the Windows NT 4.0 or Windows 2000 user account Read access to the specified ODBC System DSN registry key as follows:

    1. Determine which account is used to process the request for the ASP page.
    2. From the Start menu, click Run, type regedt32.exe, and then click OK to start Registry Editor.
    3. In the HKEY_LOCAL_MACHINE window, browse to the HKLM\SOFTWARE\ODBC\ODBC.INI key. The ODBC.INI key contains a subkey for each ODBC SYSTEM DSN that is registered on the server.
    4. Click the DSN registry key for the DSN that is specified in the ADO connection string.
    5. From the Security menu, click Permissions.
    6. Add the user account that you identified in step 1 to the list of users who can access this key, and select the Read check box for this user.
    7. Click Apply, and then close Registry Editor.



    LVL 7

    Assisted Solution

    I can recommend this site:

    It has both OLEDB and ODBC connection strings for Access.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
    I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now