Results 1 to 2 of 2

Thread: OLEDB

  1. #1
    Join Date
    Dec 1969

    Default OLEDB

    I have used the following code:<BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=c:websharewwwrootstarlinerusers.mdb; User ID=id; Password=pass" <BR>objConn.open <BR>strExec = "SELECT * from users"<BR>set rstemp=objConn.execute(strExec)<BR>and I am getting an error that the provider can&#039t be found. I have gone to microsoft and runthe checker and my mdac is recent.<BR><BR>any ideas???<BR><BR>

  2. #2
    Mark Guest

    Default RE: OLEDB

    I have had similar problems with Access OLE DB Provider, but not with Excel Provider, or with Microsoft&#039s Oracle Provider.<BR><BR>You may want to verify that you are calling the proper version of the Access Provider (OLEDB.3.51 vs. OLEDB.4.??)

Posting Permissions

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