[thelist] Oledb connection problem with Access XP
Joel D Canfield
joel at spinhead.com
Thu Nov 22 10:51:46 CST 2001
Same error.
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Driver={Microsoft Ac'
/issimo/ins_prods_response3.asp, line 20
joel
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of Paul Backhouse
Sent: Thursday, November 22, 2001 8:42 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Oledb connection problem with Access XP
Joel,
you could try this:
objConn = "Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\Inetpub\wwwroot\issimo\issimo.mdb"
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Joel D Canfield
Sent: 22 November 2001 16:37
To: thelist at lists.evolt.org
Subject: [thelist] Oledb connection problem with Access XP
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
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to: http://lists.evolt.org
Workers of the Web, evolt !
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list