[thelist] Oledb connection problem with Access XP
Joel D Canfield
joel at spinhead.com
Thu Nov 22 11:03:06 CST 2001
Ouch! That should have been obvious. I think the traditional response
is, "I need more sleep."
Thanks!
joel
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of darren
Sent: Thursday, November 22, 2001 8:51 AM
To: thelist
Subject: Re: [thelist] Oledb connection problem with Access XP
On 22 November 2001 at 16:36:37, Joel D Canfield <joel at spinhead.com>
wrote:
JDC> Any idea why this code:
JDC> Set objConn = Server.CreateObject("ADODB.Connection")
JDC> objConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
JDC> Source=c:\Inetpub\wwwroot\issimo\issimo.mdb"
JDC> strQuery="SELECT * FROM products"
JDC> Set InsProduct = objConn.Execute(strQuery)
JDC> begets this error?
cos you're trying to set your db connect to your connection string. try
objConn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Inetpub\wwwroot\issimo\issimo.mdb")
hth,
darren
More information about the thelist
mailing list