Unspecifed Error !!!! HELP - This is painful

[Guest]

This is the most excruciating error I have ever had to deal with in 10 years
of programming with Visual Basic.
I am getting an error albeit intermittent most of the time, but I am now
getting it consistently on one of my aspx pages.

the following is the error:[OleDbException (0x80004005): Unspecified Error]

It happens on either one of two calls. It happens on command.Fill or the
Connection.open

I have been through every possible area of the internet looking for a
solution to the problem. Most of the suggestions have been in the area of
permissions which I have checked, double-Checked and Quadruple Checked. I
have also looked at the locking of the database.

I am using Microsoft Visual Studio.net 2003 and Microsoft Access 2003. My
access database resides in a folder in the IIS structure.

My connection string is the following:

Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=;Mode=Share Deny
None;Data Source=C:\Inetpub\wwwroot\ceclp\dbase\ceclp_redesign.mdb

The IUSR account has read and write permissions on both the DBase folder and
the Local, Temp folders

HELP - I am committed to having to use Access as my database so I need to
resolve this issue as soon as humanly possible.

Thank tyou in advance for any help

 

[William \(Bill\) Vaughn]

Unspecified errors usually mean you have not trapped the exception.
Add a Try/Catch exception handler around your code

Try
Your code
Catch Ex as Exception
msgbox (ex.tostring)
End Try

This should tell you exactly what's wrong--not that you'll be able to fix it
'cause you're using JET/Access, but it might help.


--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP

 

[Guest]

Hi Dan,

Did you ever find a solution to this problem? I am having the same kind of
problem only it works on my WinXP/IIS 5.1 machine and not on my Win2K/IIS 5.0
server. I am using a Access database with linked tables as my datastore. If
all the database files are stored locally it works fine. But I need for the
linked tables to reside on our fileserver, which means that on the webserver
they are available through a fileshare/network drive.

Best regards
PÃ¥l Eilertsen