[thelist] Oledb connection problem with Access XP

[Paul Backhouse]

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 !