#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jun 2004
    Posts
    5
    Rep Power
    0

    Provider error '80004002' No such interface supported


    I am currently in the process of changing a website from an sql database into an access database, and I have encountered an error when opening up the database from an external file when doing certain processes. The error i recieve is:

    Providererror '80004002'


    No such interface supported
    /Refs/opendb.asp, line 28

    and the code on that page is:-

    <!--#include virtual="/Refs/SecureIt.asp"-->
    <%
    Const adOpenForwardOnly = 0
    Const adOpenKeyset = 1
    Const adOpenDynamic = 2
    Const adOpenStatic = 3

    Const adLockReadOnly = 1
    Const adLockPessimistic = 2
    Const adLockOptimistic = 3
    Const adLockBatchOptimistic = 4

    Const adUseServer = 2
    Const adUseClient = 3

    Const adCmdTableDirect = 512
    Const adCmdText = &H0001

    Dim conn, DataBase, dbProvider
    DataBase = Server.MapPath("/db/db.mdb")
    Provider = "Microsoft.Jet.OLEDB.4.0"

    Set conn = Server.CreateObject("ADODB.Connection")
    With conn
    .Provider = Provider
    ' .MODE = &H10
    .Open DataBase

    End With


    %>

    Please can anyone see what the error is and what is wrong with the code i would be very grateful.
  2. #2
  3. Spell Breaker
    ASP Adventurer (500 - 999 posts)

    Join Date
    May 2004
    Posts
    990
    Rep Power
    11

    Arrow


    Originally Posted by tripm8
    I am currently in the process of changing a website from an sql database into an access database, and I have encountered an error when opening up the database from an external file when doing certain processes. The error i recieve is:

    Providererror '80004002'


    No such interface supported
    /Refs/opendb.asp, line 28

    and the code on that page is:-

    <!--#include virtual="/Refs/SecureIt.asp"-->
    <%
    Const adOpenForwardOnly = 0
    Const adOpenKeyset = 1
    Const adOpenDynamic = 2
    Const adOpenStatic = 3

    Const adLockReadOnly = 1
    Const adLockPessimistic = 2
    Const adLockOptimistic = 3
    Const adLockBatchOptimistic = 4

    Const adUseServer = 2
    Const adUseClient = 3

    Const adCmdTableDirect = 512
    Const adCmdText = &H0001

    Dim conn, DataBase, dbProvider
    DataBase = Server.MapPath("/db/db.mdb")
    Provider = "Microsoft.Jet.OLEDB.4.0"

    Set conn = Server.CreateObject("ADODB.Connection")
    With conn
    .Provider = Provider
    ' .MODE = &H10
    .Open DataBase

    End With


    %>

    Please can anyone see what the error is and what is wrong with the code i would be very grateful.

    I would suggest for you using DSN connection.

Similar Threads

  1. Connect to sql server using ole db provider
    By dpanag in forum Microsoft SQL Server
    Replies: 0
    Last Post: March 26th, 2004, 04:59 AM
  2. "Keyword not supported: provider", C#
    By Swaroop in forum .NET Development
    Replies: 2
    Last Post: March 17th, 2004, 06:06 PM
  3. OLEDB provider
    By Ikkynikinae in forum ASP Development
    Replies: 5
    Last Post: December 2nd, 2003, 04:08 PM
  4. Calling COM interface from ASP
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: October 4th, 2000, 08:20 AM
  5. interface based com programming
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: September 19th, 2000, 09:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo