Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 08, 2010 03:19 AM by ssmc123
May 27, 2008 02:19 AM|LINK
I have same error. please help me.
Jun 09, 2008 07:00 PM|LINK
I'm having a similar issue, but with Excel in C#.
The Excel file uploads just fine and is saved locally in a temp subfolder of the page.
On Friday, my code was working just fine, but come Monday morning I'm now receiving this error on the "dataAdapter.Fill(dataset)" every time I try to read Excel into a dataset using the following, though nothing has changed.
System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
The Excel file is uploaded successfully to a temp subfolder. I'm not using impersonation, so I've tried granting full permissions to the temp folder for the local ASPNET account, even though it wasn't necessary before for this to work.
Nov 19, 2009 12:43 PM|LINK
Changing impersonation to false worked for me. I had it tested on development site; but on live site it failed. Thanks for your post.
Nov 24, 2009 12:48 PM|LINK
In production servers the OleDb components loaded on ASP.NET worker process seems to missfunction ocassionally. Restarting the IIS the problem will go away.
Dec 07, 2009 12:17 PM|LINK
I am having the same problem on server. 'hv tried with this but after some time its happening again. and w3wp.exe is taking more memory usage. please help.
Aug 26, 2010 10:33 AM|LINK
I am still facing the same problem..pls help..
Nov 08, 2010 03:19 AM|LINK
I have the same problem. Users could upload the files to the server and open it with OLEDB connection. It works fine. But, after a period of time, it returns with 'unspecific error' on OLEDB connection. After restarting the IIS, it works fine again.
But this errors seems happened frequently now.
Could anyone help me to fix this 'Unspecific error'.
Thank you very much!