I don't believe the problem is with the sql statement since it executes fine using a different connection string.
-----Original Message----- From: Robert Chartier [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:03 PM To: ActiveServerPages Subject: Re: Driver Error response.write sql just before the line set rs = conn.execute(sql) then copy and paste that output to your database's sql query analyzer and try to run it At 05:45 PM 8/14/2002 -0400, you wrote: >I implemented the OLEDB for Jet and I know get the following error. Below is >the connection string and error > >Provider=microsoft.oledb.jet.4.0;data source=c:\db.mdb > >error '80004005' >Unspecified error > >This error happens at the point of executing an sql statement. Below is an >example of one of the statements >sql = "SELECT * FROM temporary WHERE CustomerId='"&CustomerId&"' ORDER BY >item;" >set rs = Conn.Execute(sql) > >Am I doing something wrong? > > > >----- Original Message ----- >From: "Nabil Al-Hage Ali" <[EMAIL PROTECTED]> >To: "ActiveServerPages" <[EMAIL PROTECTED]> >Sent: Wednesday, August 14, 2002 2:34 PM >Subject: Re: Driver Error > > > > In such a case the best thing to do is to redefine your DSN again and make >sure to use > > the new driver for the new database system installed ( in your case MS >ACCESS 2000). > > > > if you are not obliged to use DSN connection ,try also DSNLESS connection >with OLEDB for > > Jet(Direct connection). > > > > Nabil. > > > > > Hello All, > > > > > > I am occasionally getting the following error on my application which is > > > running on WinNT, IIS4, Access2000. It was running on Access 97 and I >was > > > told to upgrade the DB to Access 2000 to stop the error. But, I am still > > > getting it. Stop/start iis stops the error. > > > > > > Any ideas? > > > > > > Line 3 is my connection string "driver={microsoft access driver= > > > (*.mdb)};dbq=db.mdb" > > > > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > > > [Microsoft][ODBC Microsoft Access Driver] Cannot open database >'(unknown)'. > > > It may not be a database that your application recognizes, or the file >may > > > be corrupt. > > > D:\IGF1STIMULANT\MP\../../marketplacecode/usPro/addcart.asp, line 3 > > > > > > > > > --- > > > You are currently subscribed to activeserverpages as: >[EMAIL PROTECTED] > > > To unsubscribe send a blank email to %%email.unsub%% > > > > > > > > --- > > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to >%%email.unsub%% > > >--- >You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >%%email.unsub%% Robert Chartier Author and Developer 604-975-5590 [EMAIL PROTECTED] http://www.aspalliance.com/nothingmn/ --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
