System.Data.OleDb.OleDbException: Unspecified error

I developed a webapplication using winxp and visual studio 2004. I deployed it on a server running win2k server. they both are using v.1.4322.573 When I try to use a part of the app that reads and excel file into a datagrid, and exception is thrown with the following info.

Server Error in '/MR' Application.
--------------------------------------------------------------------------------


Unspecified error
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.


Exception Details: System.Data.OleDb.OleDbException: Unspecified error


Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:




[OleDbException (0x80004005): Unspecified error]
   System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
   System.Data.OleDb.OleDbConnection.InitializeProvider() +57
   System.Data.OleDb.OleDbConnection.Open() +203
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
   VendorDatabase.excelHandler.excelToDatagrid(String filepath, String importType) in c:\inetpub\wwwroot\VendorDatabase\excelHandler.vb:31
   VendorDatabase.WebForm1.btnImportFileImport_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\VendorDatabase\WebForm1.aspx.vb:781
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277


 





--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

this is the code where it fails

Function excelToDatagrid(ByVal filepath As String, ByVal importType As String) As DataSet

Dim strConn As String

Dim myCommand As OleDb.OleDbDataAdapter

Dim conn As OleDb.OleDbConnection

Dim mydataset As DataSet

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filepath + ";" + "Extended Properties=Excel 8.0;Persist Security Info=False;"

conn = New OleDb.OleDbConnection(strConn)

myCommand = New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)

mydataset = New DataSet

myCommand.Fill(mydataset)

myCommand.Dispose()

Return mydataset

End Function

Re: System.Data.OleDb.OleDbException: Unspecified error

i got the same thing too.. can some help? System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal.InitializeProvider() at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnection conn, OleDbConnectionString constr) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object providerInfo, DbConnectionBase owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnectionBase owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnectionBase owningConnection) at System.Data.ProviderBase.DbConnectionClosed.Open(DbConnectionBase outerConnection) at System.Data.ProviderBase.DbConnectionBase.Open() at ASP.excel1_aspx.LoadExcelIntoDS() in c:\excel_dev\excel1.aspx:line 25 <script runat=server> void Page_Load(Object src, EventArgs e) { LoadExcelIntoDS(); } void LoadExcelIntoDS() { OleDbConnection MyConnection = new OleDbConnection(); try { String conn = "Provider=Microsoft.Jet.OLEDB.4.0;"; conn += @"Data Source=C:\excel_dev\demo_banc.xls;"; conn += "Extended Properties=Excel 8.0;"; MyConnection = new OleDbConnection(conn); MyConnection.Open(); } catch(ArgumentException ae) { Response.Write(ae.ToString() + "
"); } catch(OleDbException e) { String err_msg = ""; for (int i = 0; i < e.Errors.Count; i++) err_msg += "----------------
Index #" + i + "
Message: " + e.Errors[i].Message + "
NativeError: " + e.Errors[i].NativeError + "
Source: " + e.Errors[i].Source + "
SQLState: " + e.Errors[i].SQLState + "
"; Response.Write(err_msg + "
"); Response.Write(e.ToString() + "
"); } catch(Exception e) { Response.Write(e.ToString() + "
"); } finally { MyConnection.Close(); } }

Re: System.Data.OleDb.OleDbException: Unspecified error

Is there a reason for the "@" symbol in your connection string? However, the code seems to work in principle. Does the ASP application have read permissions over the folder that the file is in? If you step through the code in debug mode, can you see where the error is thrown? I'm puzzled as to why it does not seem to be making use of the code in the catch statements, especially as you are catching generic exceptions. What code is at line 25?

Re: System.Data.OleDb.OleDbException: Unspecified error

Sorry, I recall now that '@' is used to escape a string in C#.

Re: System.Data.OleDb.OleDbException: Unspecified error

solved. this has to do with impersonation. in web.config, i set impersonate back to false and it works. i read in another article on this forum that because when .net reads an excel file, it creats a temp folder to store the data, and that temp folder can only be access by the ASPNET account. so if you impersonate as another user on the computer / network and tried to use ASPNET to read the data in the excel file, you will not be able to.

Re: System.Data.OleDb.OleDbException: Unspecified error

i think the point here is that the asp.net user are not able to create files
in the temporary folder!
you can go to the temp folder ( ex. Document settings\servername\aspnet\)
and there on the temp folder give the full right access for the asp.net
user. i hope this may solve the problem

Gursoy DURMUS
Turkiye

Re: System.Data.OleDb.OleDbException: Unspecified error

The scripts that access databases were working fine until I had to delete the wwwroot folder and recreate it, copying the files back in again. When I copied the files back in the SQL database didn't work. After a lot of hunting about I fixed that, but now whenver a script tries to access an Access database I get the

Unspecified error

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

message appearing. I can't get rid of it, I've made sure aspnet can read/write/modify the database files and the containing directory. I've also done the above and gone to Documents and Settings\FRED\aspnet\ - there is no Temp folder so I created one and gave aspnet the permissions nescessary. I also gave it permissions on the Temp folder in Documents and Settings\FRED\aspnet\Local Setttings, but this didn't help either.

I'm at a complete loss! Help!!

Re: System.Data.OleDb.OleDbException: Unspecified error

Never mind - I eventually came across this: http://support.microsoft.com/kb/827190

Changing (actually inserting) the <identity impersonate="false" /> has fixed it.

It must have happened when I merged the two web.config files from the part I'm writing with the part my colleague did. Of all the useful error messages in the world....!

Re: System.Data.OleDb.OleDbException: Unspecified error

"Document settings\servername\aspnet"

In my Documents and Settings folder, i can't see any servername folder, only user folder, where i can find ASPNET folder in my win 2003 system [Angel] ?

Thanks !

Re: System.Data.OleDb.OleDbException: Unspecified error

May be your folder is hidden

goto tools->folder options ->view->hidden files and folders->enable show

Re: System.Data.OleDb.OleDbException: Unspecified error

I have same error. please help me.

Re: System.Data.OleDb.OleDbException: Unspecified error

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.

public DataSet ExcelRead(string ExcelFilePath, string sheetName)

{

string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""", ExcelFilePath);

string query = String.Format("SELECT * FROM [{0}$]", sheetName);

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);

DataSet dataSet = new DataSet();

dataAdapter.AcceptChangesDuringFill = true;

dataAdapter.Fill(dataSet);return dataSet;

}

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.

Re: System.Data.OleDb.OleDbException: Unspecified error

Changing impersonation to false worked for me. I had it tested on development site; but on live site it failed. Thanks for your post.

Re: System.Data.OleDb.OleDbException: Unspecified error

My experience:

In production servers the OleDb components loaded on ASP.NET worker process seems to missfunction ocassionally. Restarting the IIS the problem will go away.

Re: System.Data.OleDb.OleDbException: Unspecified error

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.

Thanks,

Re: System.Data.OleDb.OleDbException: Unspecified error

I am still facing the same problem..pls help..

Vinay

Re: System.Data.OleDb.OleDbException: Unspecified error

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!