DataSource Controls :: Generates Unspecified Error On Opening File On Production Server
Jan 5, 2010
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).
string connectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";") + "Extended Properties="Excel 8.0""
OleDbConnection connection = null;
connection = new OleDbConnection(connectionString);
connection.Open();
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.
View 4 Replies
Similar Messages:
May 5, 2010
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:
[Code]....
View 1 Replies
Dec 27, 2010
I encrypted my web.config file and I copied this file to the production server. But I get an error. But without encrypting - it's ok. I used:
C:WindowsMicrosoft.NETFramework64v4.0.30319aspnet_regiis -pef "appSettings" "C:inetpubwwwrootSite1" -prov RsaProtectedConfigurationProvider
I don't have access to IIS. Is it possible to encrypt config file and everything works?
View 3 Replies
Jun 20, 2010
I'm building a custom control that has a ValidationText property of type List<string>. The value of the property is rendered as a comma-delimited string in the XHTML code. Changing the value in the String Collection editor updates the XHTML code and vice versa. So everything seems to work at design time. But... when I run the project I get a parser error:
"Cannot create an object of type 'System.Collections.Generic.List`1[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' from its string representation 'hh,ss' for the 'ValidationText' property."
Here is the code for the property:
[Code]....
...and the Typeconverter:
[Code]....
View 2 Replies
Jul 8, 2010
how to transfer my data from devlopment server to production server ,i have already records exist in my database if i go for script then how can i transfor record in script i can transfor only table ,procedure and views.I am using SqlServer 2005.
View 2 Replies
Feb 22, 2011
The inline code
<% for (int i = 0; i < ThumbnailList.Items.Count; i++)
{ Response.Write("thumbnailViews[" + i.ToString() + "] = $find('" +
ThumbnailList.Items[i].FindControl("ThumbnailView").ClientID + "');
"); } %>
produces a bunch of compile time errors in Visual Studio 2008 - although it works fine.
But this seems to be the exact way inline code should be added, at least according to this MS help file:
[URL]
The errors are:
expected expression (at "<%")
expected ';' (at "int i")
expected ')' (at ThumbnailList.Items.Count;
expected ';' (at " i++)")
I have done a
<%@ Page Language="C#" ...
at the top of the file.
View 1 Replies
Dec 10, 2012
When I click the button it's giving an error "Illegal characters in path.",instead opening the pdf file
protected void Button2_Click(object sender, EventArgs e)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=TestPage1.pdf");
[Code].....
View 1 Replies
Jan 22, 2010
While writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
View 2 Replies
May 14, 2010
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.
Exception Details: System.Runtime.InteropServices.COMException: Unspecified error
Source error:
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: {
Stack trace:
[COMException (0x80004005): Unspecified error ] System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) +377678 System.DirectoryServices.DirectoryEntry.Bind() +36 System.DirectoryServices.DirectoryEntry.get_AdsObject() +31 System.DirectoryServices.DirectorySearcher.FindAll(Boolean
findMoreThanOne) +78 System.DirectoryServices.DirectorySearcher.FindAll() +9 SysSup.TechApps3.DataLayer.Workstation.GetWorkstationsByOU(String adsPath) in c:Documents and SettingssysvrjoshiDesktopComputer Management ProjectApp_CodeWorkstationManagementWorkstation.cs:284
[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder,
Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +261 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod
method, Boolean disposeInstance, Object& instance) +488 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1247 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback
callback) +19 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +44 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal()
+171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842
View 4 Replies
Feb 16, 2010
I have a SQL server in my office. I can connect from my home development workstation website to the remote SQL server with no problems but when I upload the site to the web host and try and use the same SQL server it fails with 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible'
View 4 Replies
Jul 2, 2010
I am actually using 2 type of queries in my website e.g
These Queries are from my stored procedures
SELECT * FROM TblName WHERE FREETEXT(ColumnName, @parameter)
AND
SELECT * FROM TblName WHERE CONTAINS((Column1, Column2), @parameter))
I have enabled Full Text Indexing on my tables both local and on my hosting company MS SQL Server.
The above queries are working fine on my local database and return results but these queries return nothing when i try to run them on hosting company MS SQL Server.
I have identical data on both MS SQL Servers and both servers are 2008.
View 2 Replies
May 10, 2010
I used visual studio 2008 and sql server 2005(for database) in my website project. After finishing my project i used publish to web option and got the files into an folder. I have installed .NET framework ,IIS, i have also set the remote connection ,firewall setting etc. But when i run i.e., In the IIS manager when i click browse it gives me the following error. Can anyone pls tell me what went wrong in this. My code works fine when run on visual studio 2008. Server Error in '/EBUSINESS' Application.
View 1 Replies
Mar 7, 2011
I have a site that is running on a Windows Server 2008 machine with IIS 7.0, when I try to open it with Visual Web Developer 2010, it says the following:
error: unable to open site: ... The Web server does not appear to have FrontPage Server Extensions installed.
Looking on the server Frontpage Extensions 2002 are installed, so what could be wrong?
The thing is, I used to be able to open the project and work on it, etc...
Open Website -> Remote Site -> Enter remote site name -> tries to open & error above!
View 1 Replies
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);
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
View 2 Replies
Dec 18, 2010
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
View 1 Replies
Jul 22, 2010
I have uploaded all my pages in httpdocs, and created a data bese ... I have also chaned the connection string acordingly but still i am geting following error on opening the page....:-
Server Error in '/' Application.
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 <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
[Code].....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
[Code]......
View 6 Replies
Oct 6, 2010
when I save the file that is returned by Handler and try to open it I get the following message:"The file you trying to open, 'Users.xls', is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now?" How to fix this? Here the code of the handler:
[Code]....
View 3 Replies
Apr 14, 2010
I have an ASP.NET web application that has the following settings in the web.config file:
[Code]....
(The actual names are different, obviously.) I am not a member of the real "Valid Site Users" group which is why I am given explicit access.I am able to access the site without a problem while developing and debugging locally; however, I get a 401 (Unauthorized Access) error when I deploy the site to a server. The only way to gain access is to remove the <deny> element from the configuration, which is not an acceptable option.I'm certain the solution is something simple and I am just overlooking
View 8 Replies
Jan 22, 2011
I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current
ustom error settings for this
application prevent the details of the
application error from being viewed
[code]...
View 2 Replies
Aug 27, 2010
I'm using asp.net 2.0 (VS2005) on a windows 2008 server.
i'm using MS Office 2007
when open word docuemnt from server using the following code -
Response.ContentType = "application/ms-word";
Response.AppendHeader("Content-Disposition", "attachment; filename= " + strDocName);
Response.TransmitFile(Server.MapPath(Defpath1));
Response.End();
it works fine when i run it in debug mode, but gives the following error when running through IIS Problems during Load Problems came up in the following areas during loadMissing file:
QTnicFLJ5JKZN8dyEzUEsK2jPtygbkw....
View 1 Replies
Oct 1, 2010
I run a asp.net 4.0 website. (I did the porting from version 3.5 to 4.0)I receive the following error :ASP.NET AJAX client-side framework failed to loadn a page where I set scriptmanager EnableCdn="true" and there is a microsoft ajax extension Timer on the page.
[Code]....
I receive the error only on the production server.
View 4 Replies
Aug 18, 2010
I have an ASP.NET project that also uses a SQL MDF File. My target server is SQL 2008R2 or SQL Azure.I would like to know what deployment options I have as I migrate from DEV to PROD. In case it matters I'm not under any regulation to maintain PII or similarly private data.
View 3 Replies
Jan 11, 2011
We have had some problems with using a unmanaged DLL file written in Delphi. (Unable to load dll - not found...)The following code solved the problem on my local machine:
[Code]....
1) The elusive DLL is copied to the ASP.NET temporary files folder2) To check this we get a list of files from that folder.3) The needed function is called with DLL-import.1 & 2 works perfectly - both run directly from Visual Studio 2010 and when uploaded to a webhotel3 works perfectly local, but causes the remote host to think a little and then return a HTTP 503 Service Unaviable error for the next few minutes...
View 1 Replies
Nov 23, 2010
I'm not able to open the file when I click on the link on page in MVC. I get the following message. I've added the impersonation in the code. I'm able to delete and save the file.
Access to the path '\servernamefolder1folder2folder3foder4filename.pdf' is denied. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path '......same as above....' is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
Source Error:
[Code]....
Source File: C:Posfx runkposfxcamonlineControllersApplicationController.vb Line: 37 Stack Trace:
[Code]....
View 6 Replies
Feb 16, 2010
i am using the following code to open a word document from asp.net application
[Code]....
but i am unable to open it.the error is "the file could not be found" but if i replace
Response.Cache.SetCacheability(HttpCacheability.NoCache);
with
Response.Cache.SetCacheability(HttpCacheability.Public);
i am able to open and save the file
View 6 Replies
