[thelist] Oledb connection problem with Access XP - renewed
Joel D Canfield
joel at spinhead.com
Thu Nov 22 12:48:51 CST 2001
Hey, look! I can reply to my own post!
The primary reason I was trying the oledb driver again (after failing to
make it work a month ago) was that it was recommended to avoid this
error
Error Type:
Provider (0x80004005)
Unspecified error
/issimo/ins_prods_response.asp, line 14
Which I'm STILL getting. Any more ideas?
Is developing with Access really that much harder than SQL? I've been
working with SQL7/2000 for a year, and it's a dream. Access continually
frustrates me, but it's how this project needs to work.
Thanks again for the continued support.
joel
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of Joel D Canfield
Sent: Thursday, November 22, 2001 9:04 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Oledb connection problem with Access XP
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
---------------------------------------
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