[thelist] Oledb connection problem with Access XP

Joel D Canfield joel at spinhead.com
Thu Nov 22 10:35:26 CST 2001


Any idea why this code:

     Set objConn = Server.CreateObject("ADODB.Connection")
     objConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Inetpub\wwwroot\issimo\issimo.mdb"

     strQuery="SELECT * FROM products"

     Set InsProduct = objConn.Execute(strQuery)

begets this error?

     Error Type:
     Microsoft VBScript runtime (0x800A01A8)
     Object required: 'Provider=Microsoft.J'
     /issimo/ins_prods_response2.asp, line 20

My environment is Windows 2000 Pro and Access XP (2002). The path to the
database in the objConn string is correct. The database is not password
protected, and IUSR_machinename has full control of the full path to the
db.

Thanks

joel at spinhead.com





More information about the thelist mailing list