Hello all, i'm really frustrated. i've been working on this database since 
february and all of sudden yesterday i began receiving an 'unspecified 
error' error. this error has lead to a number of different errors that 
occur while i try to access my database. anybody know what i should do? 
thanks,

TML

If it has been working for a while, something has changed on your server or
machine. 

Have you installed any patches, etc. or uninstalled anything?

Isn't there a filter that can be taken off of IIS or the operating system
that will
allow the display of those nice, juicy nasty error messages?

Karri

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:01 PM
To: Access ASP
Subject: [access_asp] unspecified error?


Hello all, i'm really frustrated. i've been working on this database since 
february and all of sudden yesterday i began receiving an 'unspecified 
error' error. this error has lead to a number of different errors that 
occur while i try to access my database. anybody know what i should do? 
thanks,

TML

I haven't installed or uninstalled any patches that i know of, but i am 
also not the systems admin here. how do i check if anything has been 
changed on the server?

TIM

> If it has been working for a while, something has changed on your server 
or
machine. 

Have you installed any patches, etc. or uninstalled anything?

Isn't there a filter that can be taken off of IIS or the operating system
that will
allow the display of those nice, juicy nasty error messages?

Karri

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:01 PM
To: Access ASP
Subject: [access_asp] unspecified error?


Hello all, i'm really frustrated. i've been working on this database since 
february and all of sudden yesterday i began receiving an 'unspecified 
error' error. this error has lead to a number of different errors that 
occur while i try to access my database. anybody know what i should do? 
thanks,

TML

ask your admin for starters.  What work on your database have done lately?  
Is it distinctive in any way from anything you did previously?

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:19 PM
To: Access ASP
Subject: [access_asp] RE: unspecified error?


I haven't installed or uninstalled any patches that i know of, but i am 
also not the systems admin here. how do i check if anything has been 
changed on the server?

TIM

> If it has been working for a while, something has changed on your server 
or
machine. 

Have you installed any patches, etc. or uninstalled anything?

Isn't there a filter that can be taken off of IIS or the operating system
that will
allow the display of those nice, juicy nasty error messages?

Karri

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:01 PM
To: Access ASP
Subject: [access_asp] unspecified error?


Hello all, i'm really frustrated. i've been working on this database since 
february and all of sudden yesterday i began receiving an 'unspecified 
error' error. this error has lead to a number of different errors that 
occur while i try to access my database. anybody know what i should do? 
thanks,

TML

the admins are saying they haven't installed anything on this particular 
computer.  since yesterday i've closed connections and set them equal 
to 'nothing'. i also added a couple session variables. but this is all 
stuff i've been doing for months now. i read that closing access while a 
connection is open can bug the machine. not sure if i did that or what. 
but where do i even begin to check if anything has been changed?

TL

> ask your admin for starters.  What work on your database have done 
lately?  
Is it distinctive in any way from anything you did previously?

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:19 PM
To: Access ASP
Subject: [access_asp] RE: unspecified error?


I haven't installed or uninstalled any patches that i know of, but i am 
also not the systems admin here. how do i check if anything has been 
changed on the server?

TIM

> If it has been working for a while, something has changed on your server 
or
machine. 

Have you installed any patches, etc. or uninstalled anything?

Isn't there a filter that can be taken off of IIS or the operating system
that will
allow the display of those nice, juicy nasty error messages?

Karri

-----Original Message-----
From: Tim Lyons [mailto:lyno@h...]
Sent: Friday, June 14, 2002 12:01 PM
To: Access ASP
Subject: [access_asp] unspecified error?


Hello all, i'm really frustrated. i've been working on this database since 
february and all of sudden yesterday i began receiving an 'unspecified 
error' error. this error has lead to a number of different errors that 
occur while i try to access my database. anybody know what i should do? 
thanks,

TML

What is your connection string? If you are using an ODBC DSN or DSN-less
connection string, try changing to using the native OLEDB provider:

www.adopenstatic.com/faq/whyOLEDB.asp

If that doesn't help, try updating your Jet drivers to Service Pack 6 (after
updating your MDAC to the latest version):

www.microsoft.com/data/ (to download MDAC v2.7)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010 (to download
Jet Service Pack 6)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tim Lyons" <lyno@h...>
Subject: [access_asp] unspecified error?


: Hello all, i'm really frustrated. i've been working on this database since
: february and all of sudden yesterday i began receiving an 'unspecified
: error' error. this error has lead to a number of different errors that
: occur while i try to access my database. anybody know what i should do?
: thanks,
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hello all,

I have a select statement in my asp page and when i execute it i receive 
an "(0x80004005) Unspecified error" message. What's strange to me is 
that, when i remove a column from the select statement, the query runs 
smoothly and no error appears. This column is a text(1) datatype in an 
Access database, which i use to store 2 boolean values: "y" an "n". But i 
is just plain text column.

Can anybody help me on this??

Thanks in advance

Nick

Can you please post your SELECT statement?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Nikos" <nikosdra@l...>
Subject: [access_asp] unspecified error


: I have a select statement in my asp page and when i execute it i receive
: an "(0x80004005) Unspecified error" message. What's strange to me is
: that, when i remove a column from the select statement, the query runs
: smoothly and no error appears. This column is a text(1) datatype in an
: Access database, which i use to store 2 boolean values: "y" an "n". But i
: is just plain text column.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~