Last post Sep 19, 2013 02:05 AM by Calvinx
Aug 20, 2003 10:50 PM|kurdtsson|LINK
Server Error in '/MR' Application.
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
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.
[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
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
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
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
Nov 30, 2004 10:51 PM|hltommy|LINK
Dec 01, 2004 03:40 AM|rohan_p|LINK
Dec 01, 2004 09:08 PM|rohan_p|LINK
Dec 14, 2004 08:07 PM|hltommy|LINK
Nov 01, 2005 09:02 AM|gdurmus|LINK
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
May 03, 2007 11:04 PM|nerd.|LINK
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
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!!
May 03, 2007 11:10 PM|nerd.|LINK
Never mind - I eventually came across this: http://support.microsoft.com/kb/827190
Changing (actually inserting) the <identity impersonate="false" /> has fixed it.
Jul 20, 2007 12:18 AM|linhlinhmail|LINK
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] ?
Oct 29, 2007 07:11 AMfirstname.lastname@example.org|LINK
May be your folder is hidden
goto tools->folder options ->view->hidden files and folders->enable show
May 27, 2008 02:19 AM|kimsea|LINK
I have same error. please help me.
Jun 09, 2008 07:00 PM|pdm2|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|padtes|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|algorithmer|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|darshanthacker|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|getvinay|LINK
I am still facing the same problem..pls help..
Nov 08, 2010 03:19 AM|ssmc123|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!
Sep 19, 2013 02:05 AM|Calvinx|LINK
I have the same problem. May I know whether there is any solution for this problem?