UPLOAD ERROR - in real Web Server
-
Hi, I encountered problem during uploading of my excel file 3MB size. At first, when I test my upload.aspx in my local web server it works fine, but after I added my upload.aspx file into the real web server and when I test, it gives an error. Please see the error below. And as I do some research some of the developers have the same problem and there's no definite solution yet. Can this be fixed, but how? Server Error in '/' Application. -------------------------------------------------------------------------------- Failure creating file. 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: Failure creating file. Source Error: Line 627: Line 628: Dim objConn As OleDbConnection = New OleDbConnection(sConnectionString) Line 629: objConn.Open() Line 630: Line 631: Dim objCmdSelect As OleDbCommand = New OleDbCommand("Select * From [Summary Parts$]", objConn) Source File: E:\inetpub\vhosts\subdomains\test\httpdocs\Upload.aspx.vb Line: 629 Stack Trace: [OleDbException (0x80004005): Failure creating file.] System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1054769 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.OleDb.OleDbConnection.Open() +37 Upload.Page_PreRender(Object sender, EventArgs e) in E:\inetpub\vhosts\pathfinder.ph\subdomains\test\httpdocs\Upload.aspx.vb:629 System.Web.UI.Control.OnPreRender(EventArgs e) +2069324 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
hifiger2004
-
Hi, I encountered problem during uploading of my excel file 3MB size. At first, when I test my upload.aspx in my local web server it works fine, but after I added my upload.aspx file into the real web server and when I test, it gives an error. Please see the error below. And as I do some research some of the developers have the same problem and there's no definite solution yet. Can this be fixed, but how? Server Error in '/' Application. -------------------------------------------------------------------------------- Failure creating file. 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: Failure creating file. Source Error: Line 627: Line 628: Dim objConn As OleDbConnection = New OleDbConnection(sConnectionString) Line 629: objConn.Open() Line 630: Line 631: Dim objCmdSelect As OleDbCommand = New OleDbCommand("Select * From [Summary Parts$]", objConn) Source File: E:\inetpub\vhosts\subdomains\test\httpdocs\Upload.aspx.vb Line: 629 Stack Trace: [OleDbException (0x80004005): Failure creating file.] System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1054769 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.OleDb.OleDbConnection.Open() +37 Upload.Page_PreRender(Object sender, EventArgs e) in E:\inetpub\vhosts\pathfinder.ph\subdomains\test\httpdocs\Upload.aspx.vb:629 System.Web.UI.Control.OnPreRender(EventArgs e) +2069324 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
hifiger2004
The failure is coming in that the Connection to the DB is not being made correctly. Check your web.config and make sure that your connection string (sConnectionString) is valid and points to the IP or server name of the Database correctly as well as checking all your concerned settings. This tends to be either: an IIS issue on the Web Server or a web.config typo. My suggestion is to start with the web.config and make sure you can establish a valid connection by trying to fill a "Hello World" table first; then work backward from there.
-
The failure is coming in that the Connection to the DB is not being made correctly. Check your web.config and make sure that your connection string (sConnectionString) is valid and points to the IP or server name of the Database correctly as well as checking all your concerned settings. This tends to be either: an IIS issue on the Web Server or a web.config typo. My suggestion is to start with the web.config and make sure you can establish a valid connection by trying to fill a "Hello World" table first; then work backward from there.
Hi, This is how I create a connection for my spreadsheet in excel. The source code below about connecting to excel has no problem when accessing it in the local web server, but when accessing it from real web server the error appears. I can't figure it out if what's really wrong. Source code Error: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & FileUpload.FileName.ToString & ";" _ & "Extended Properties=Excel 8.0;" ' Create connection object by using the preceding connection string. Dim objConn As OleDbConnection = New OleDbConnection(sConnectionString) ' Open connection with the database. objConn.Open() ' The code to follow uses a SQL SELECT command to display the data from the worksheet. 4158531 - 33 ' Create new OleDbCommand to return data from worksheet. Dim objCmdSelect As OleDbCommand = New OleDbCommand("Select * From [summary$]", objConn)
hifiger2004