If you are using Windows2000 or WindowsXP I'd recommend either: a) trying to update your MDAC components to the latest version: www.microsoft.com/data Don't forget to apply Jet Service Pack 6: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010&;
b) If this does not fix the problem, I think something is hosed in your MDAC components - do an "in place" repair of your existing Windows2000/XP installation. Your programs and settings will remain, but you will need to reapply service packs (eg Win2k SP3), and hotfix updates. Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Zaid Abdur-Rahman" <[EMAIL PROTECTED]> Subject: Re: Driver Error : oopps, that was a typing mistake. the actual connection string reads : Provider=Microsoft.Jet.OLEDB.4.0; : : ----- Original Message ----- : From: "Ken Schaefer" <[EMAIL PROTECTED]> : To: "ActiveServerPages" <[EMAIL PROTECTED]> : Sent: Thursday, August 15, 2002 12:32 AM : Subject: Re: Driver Error : : : > Hi, : > : > This is what you are using for the Provider name: : > Provider=microsoft.oledb.jet.4.0; : > : > Now look very closely at the one here: : > http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet : > : > Notice there is a slight difference in the order of OLEDB and Jet : > : > Cheers : > Ken : > : > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : > From: "Zaid Abdur-Rahman" <[EMAIL PROTECTED]> : > Subject: RE: Driver Error : > : > : > : 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 PROTECTED]
