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 PROTECTED]
