System.Data.OleDb.OleDbException: Unspecified error

March 17th, 2010

I ran across this error in an ASP.NET project that was using ADO.NET to access the data in a .csv file (more info here). After much gnashing of teeth, I finally ran across this blog post, that explained the problem and provided a link to this MSDN article.

Basically, you need to make sure that the user has permissions on both the file in which the .csv file resides, and also the file in which the Jet Engine will create temporary files. It is this last piece that I didn’t know, and lead to days of heartache.

So I thought I’d post, in the hopes of minimizing the heartache for others…

Posted in ASP.NET, All | Trackback | del.icio.us | Top Of Page

Leave a Reply

You must be logged in to post a comment.