On Fri, 27 Oct 2006 16:12:07 -0500, "Johndow" <liz***@hotmail.com> wrote:

>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" <ph***@emailaddress.com> wrote in message
news:mrl6k25hrhpeoek5gd3oisvffmoamsrvp1@4ax.com...
> On Fri, 27 Oct 2006 16:12:07 -0500, "Johndow" <liz***@hotmail.com> wrote:
>
>>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" wrote:

> 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?
>
> "Otis Mukinfus" <ph***@emailaddress.com> wrote in message
> news:mrl6k25hrhpeoek5gd3oisvffmoamsrvp1@4ax.com...
> > On Fri, 27 Oct 2006 16:12:07 -0500, "Johndow" <liz***@hotmail.com> wrote:
> >
> >>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
>
>
>