intermittent Unspecified error on Microsoft Jet Database Engine

[Johndow]

It is a very strange issue. I try to use oledb to access a flat text file
on the file system, and got intermittent error: I dump the error into a log,
which does not show much information:

Message: Unspecified error
Source: Microsoft JET Database EngineStackTrace: at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()

The connection string I used is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\FlatFileUpload\;Extended
Properties="text;HDR=YES;FMT=Delimited"

I have read article at http://support.microsoft.com/kb/251254/
What frustrate me is if it is a permission issue, why sometimes it works and
sometimes it does not?

Anyone has similar experience before? Your comments are greatly
appreciated.

 

[Otis Mukinfus]

It is a very strange issue. I try to use oledb to access a flat text file
on the file system, and got intermittent error: I dump the error into a log,
which does not show much information:

Message: Unspecified error
Source: Microsoft JET Database EngineStackTrace: at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()

The connection string I used is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\FlatFileUpload\;Extended
Properties="text;HDR=YES;FMT=Delimited"

I have read article at http://support.microsoft.com/kb/251254/
What frustrate me is if it is a permission issue, why sometimes it works and
sometimes it does not?

Anyone has similar experience before? Your comments are greatly
appreciated.

When the error occurs is it always with the same user? Are you opening the
database as the user MACHINE_NAME/ASPNET? If so, did you follow the
instructions in the article regarding the permissions on the temporary folder?

If you are not using MAHCINE_NAME/ASPNET to connect to the database, then it may
intermittent if the user is not always the same and some users don't have
permissions to write the temp folder.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

 

[Johndow]

Thanks for the reply.
The project is a web application, so the user is always Machine_name/ASPNET.
I followed the article to assigned the permission to the temp folder,
however what puzzled me is the intermittent error. Any ideas?

 

[Guest]

Hello, do you use Access

I have the same error using access in a web application. I think that maybe
could be the number of open connections. But I'm not sure. Somebody have an
idea?

The thing is that sometimes it works an sometimes dosen't, and is not in the
same code part...
thanks.