[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