[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