Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Provider error '80004002' No such interface supported

Results 1 to 2 of 2
Share This Thread →
  1. #1
    tripm8 is offline Registered User
    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
    beercraft_asp's Avatar
    beercraft_asp is offline Spell Breaker
    Join Date
    May 2004
    Posts
    990
    Rep Power
    10

    Arrow

    Quote 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.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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, 03:59 AM
  2. "Keyword not supported: provider", C#
    By Swaroop in forum .NET Development
    Replies: 2
    Last Post: March 17th, 2004, 05:06 PM
  3. OLEDB provider
    By Ikkynikinae in forum ASP Development
    Replies: 5
    Last Post: December 2nd, 2003, 03:08 PM
  4. Calling COM interface from ASP
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: October 4th, 2000, 07:20 AM
  5. interface based com programming
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: September 19th, 2000, 08:23 AM

ASP Free Advertisers and Affiliates