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]
