Configuration :: Unspecified Error While Uploading Excel And Connecting It To Dataset
Aug 26, 2010
I am facing some problem while uploading excel sheet upload and connecting it to dataset. The Code works fine in local machine but on website its showing following error.
System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal
Below is my code:
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
switch (Extension)
{
case ".xls": //Excel 97-03
s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
case ".xlsx": //Excel 07
s = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
}
EDT = new DataTable();
EDT.Columns.Add("MobileNo", typeof(string));
con = new OleDbConnection(s);
con.Open(); // I am getting the error at this point
da = new OleDbDataAdapter("select * from [Sheet1$]", con);
ds = new DataSet();
da.Fill(ds);
What I am thinking is this? Is it possible for me to upload the data from an excel file to dataset of my application first, so that the user can view the data in a gridview to review it first, before the user strike the save button, to save it in the database. So, that in case there is a problem, the gridview will high light all the data with an error. So the user can easily pull out the excel and correct the data before saving it in the database.
I facing a problem when I upload a file from my side while the application is running in server.
The error shows below:
'C:Excel FilesStaff Directory1.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I upgraded a Website to use ASP.NET 4.0, from 3.5. This involved setting it up on a different server, with the same hosting company. I'm using a shared hosting plan on Windows Server 2008.
Since migrating, it gives an error message when I try to login to the site:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I'm using the same connection string as I did in the old version, which always worked. I also changed the permissions for the database to allow connections from the redeployed Website, via the host's control panel.
I have searched the web.config, and the source for the site, and I haven't been able to find a connection string that looks incorrect.
I've contacted the host about it, in case it is a configuration issue on their side.
I have the following error. Iam trying to put the method in try catch but still not sure what to put in catch. I am trying to make it thow an exception due to the folloing 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.
Line 282: directorySearcher.PropertiesToLoad.Add("cn"); Line 283: directorySearcher.PropertiesToLoad.Add("adsPath"); Line 284: SearchResultCollection computerCollection = directorySearcher.FindAll(); Line 285: foreach (SearchResult computer in computerCollection) Line 286: {
i have created my website in vs 2008 using the localhost, now i want to upload it to my uni server. i have transferred all the files to the server but am getting this error. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. Source Error:
Line 76: ASP.NET to identify an incoming user. Line 77: --> Line 78: <authentication mode="Windows"/> Line 79: <!-- Line 80: The <customErrors> section enables configuration
i'm doing a website for a school and after uploading the site i get this error when typing in the web address: "Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". "
the problem i have is the hosting company are saying it's not them and their IIS server is supporting .net 2.0 and it must be my code. i have even tried creating a brand new site and uploading that and I still get the same error. Because it's a school website i have to use the local government's hosting company so can't go anywhere else to host it. my question is is there any way i can create a website in .net 1.1 in vs? that way i can try to upload that site and see if it's displayed; at least if it does I can go back to the hosting company and tell them it's their server.
have a web application which will allow me to upload files to my web folder. I have used the following code for uploading files (VB) on click of BUTTON UPLOAD
If FileUpload1.HasFile Then Try FileUpload1.SaveAs(Server.MapPath("/UPLOADS/" & FileUpload1.FileName))
Now i'm using visual studio 2008 for my web application project development. I had more than 80 forms and more than 20 modules include with it. Today morning i working with my applicatons normally. Suddenly i cant debug my applications but when i tried to run the webform by View in Browser option, The seperate form shows the page and output. And i cant dubug or Run my Whole project manually. When i tried to debug the applications, suddenly the below error pop-up will displayed without any debuging.
The Operation Could not be completed. unspecified error
I am usig ADO.NET to fetch a Dataset and then exporting the data to excel using Response.Write with response type set as excel. However when I run the application I am getting the following error in the browser."Cannot view XML input using XSL style sheet. Please correct the error and then click theRefresh button, or try again later."Anybody has any idea on why do we get this error and any pointers to resolve this error? By the way the same code does works on another machine, it's just not working on few machines.
I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object using the .open() method on the object instance. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production server only. The application works fine on two other servers (development and testing servers).
The exception comes on production server at connection.Open() some times, when I reset the asp.net worker process it started to work but after some hours/days It occurs again. how can I fix this issue which comes in production some times but very irritating, or there is some other work around.
I am developing one web application using MS Access database using oledb connection.Previously i checked the same application is works well in the same machine.Now Today i checked they provide "Unspecified Error". And also Provide the following Exception:
System.Data.OleDb.OleDbException: Unspecified errorat 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 clsOledbClass.opencon() in c:inetpubwwwrootcheckNPCApp_CodeclsOledbClass.cs:line 64
I am using the following connection string for connecting database:
I am developing a simple web app on Visual Studio 2010 on Vista, using Local IIS. When I ran I got this error message:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
For this app, I did the following.
-- Add Reference of Microsoft Excel 12.0 Object Library from WebSite option on Visual Studio 2010.
-- Here is the code: (Error occured @ Dim xii2 As New Excel.application). The identical code and idential Add Reference were fine when developed under window .net asp
application, not web app. Imports Microsoft.Office.Interop Partial Class _Default Inherits System.Web.UI.Page
I have created a crystal report using dataset(.xsd) in asp.net,c#. It is working fine on local machines and my local machine IIS. on my local machine windows7 is installed. When I uploading it on on windows 8 IIS then data is not coming. Dataset is not filling on windows8 IIS.
I have written a method for getting information about the ip-addresses of visitors to my web site. The method is called from Page_Load. It connects to the Ripe whois database and gets information about the ip sent. Everything works perfectly when I try it locally using localhost, but as soon as I upload the code to my web host it stops working, and I get the following error message saying that it can't connect to Ripe. The code is exacly the same as I use locally. (The relevant code is included in the error message below). I tried to contact my web host to ask them, but they said it was beyond their expertise...
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 193.0.6.135:43
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.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 193.0.6.135:43
Source Error: [Code]....
Line 38: {Line 39: TcpClient objTCPC = new TcpClient();Line 40: objTCPC.Connect("whois.ripe.net", 43);Line 41: Line 42: string strDomain = ip + "
My Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
I have a web page which I have created to allow users to upload excel file sheet and thus these sets of data will be inserted into the database. However, as I was testing out, I realized that if the excel file is too large (i.e. mulitple sheets, > 5 sheets) , the portal may not be able to handle the large amount of data and displayed error message like the connection is reset. I tried it with only less than 5 sheets it will be fine. Any idea if there are any codes or mechanism which could solve this problem?
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
I am having 5 systems connected through LAN.Now I am creating a web application in server and want to retrive that web application through all the systems so that other people can able to access it andwork with different pages in the application.Is this possible?If yes pls send me the steps how to do that?Same with database also.Pls respond me ASAP.
I want to restrict duplicates while uploading the excel data and to inform the user that the perticular cell in excel contains duplicate value which is already exist in Sql Database.(Duplicates should be check in Excel (EMP_ID) against SQL (EMPLOYEE_ID)
SQL DATABASE
Table : Employees
FiledName:EMPLOYEE_ID
Excel DATABASE
Sheet: Sheet1
Column: EMP_ID
Message should display as:user cannot upload the data to with duplicate values. Kindly remove the duplicate fields and re-upload.
What is the efficient way to upload excel data to sql database?excel file consists of 4000 rows..so i need to save these records to sql database in web application,i know only by creating ODBC connection i.e
_path = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + _path; OdbcConnection _xlsConn = new OdbcConnection(_path); _xlsConn.Open(); OdbcCommand _xlsSelSht = new OdbcCommand("Select " + columns + " FROM [" + _sheet + "$]", _xlsConn); OdbcDataReader _xlsReader = _xlsSelSht.ExecuteReader(); while (_xlsReader.Read()){.....}
I am looking for best practice for uploading excel data in Sql server 2000 database through asp.net web application. Excel data will be predefined Format with almost 42 columns and out of 42 10 fields are mandatory and rest are conditional mandatory. i.e. if data exists it should be in defined format. I also need to validate for special character, length, specified format and so on.After validating, i need to store valid data into sql server table and provide export to excel functionality for invalid data for exporting in same excel format with indicator to identity the invalid cells.