ADO.NET :: Getting Data From Excel In 64bit?
Nov 21, 2010How can I read Excel 2007 files using C# code on a 64bit server?
View 2 RepliesHow can I read Excel 2007 files using C# code on a 64bit server?
View 2 RepliesApologies if this is is in the wrong place but I'm not sure where this issue fits. My issue deals with setting up an ASP.NET 64bit website on IIS6 (W2003 R2) so it could be a compiling problem or an IIS setup issue - I've read so much now I'm all tied up in knots.I have a web app which has been written on top of my company's custom framework, both have been compiled in .Net 2.0 with the "AnyCPU" option and run quite happily on my laptop within Visual Studio 2008 (on a Windows 7 Enterprise 64bit laptop). All of the code is managed code with the exception of 1 3rd party dll that I think is still 32bit.
Question 1: when running on my laptop in VS, is my web app running in 32bit or 64bit mode, given the OS is 64bit? I have both versions of .NET 2.0 installed.I have a new desktop that is to be our test server, and has been installed with Windows 2003 R2 and had IIS6 configured (same as the production environment). Again, both versions of .NET 2.0 are installed. When I copy my web app to the server and browse to the site, I get the dreaded "%1 is not a valid Win32 application", and sometimes (depending on what settings I've been playing with) "Service Unavailable" messages. If I register the .NET version to 32bit, and set the IIS 'Enable32bitAppOnWin64' to true, the app runs happliy the same as when on my laptop......but I don't want it to do that! I want to run IIS to run in 64bit mode with the 64bit .NET 2.0 Framework!Question 2: What does IIS see to make it think that my app is a Win32 app or am I interpreting that message wrong? Is the fact that I have 1 32bit dll in the in folder enough for IIS to say "32bit" and keel over?
My understanding of the "AnyCPU" option was that as long as the code is all managed code within the application, the bitness of the OS does not matter so I cannot understand why IIS6 cannot run the app in 64bit mode....and no, installing IIS7 is not an option.
My asp.net 2005 old application was working on windows 2003 server. I have used asp.net hashcode method to store user password in database. Now I shifted my asp.net 2005 application on windows 2008 R2 server. But my Password hashcode logic is not working due to 64bit windows 2008 server architecture & 64 bit IIS 7. I dont want to set IIS on 32bit mode.
So How can I check my 32bit user password on windows 2008 64bit server with 64 bit IIS without changing hashcode logic?Â
Trying to get my server updated with 64bit versions of .net 3.0 sp1, 3.0 sp2, and 3.5 sp1 before instaling 4.0. However. ASP.NET Download page only gives me one option - download and install windows platform installer with 4.0 and it doesn't seem to even realize that I am running 64bit.
I'm trying to deploy a site to a 64bit OS. I'm deploying to IIS6. The site was developed on a 32bit server. The site deployed correctly however it's trying to access a COM component and that is failing.
I believe the error is occurring because the COM component is a 64bit version on the 64bit OS. And IIS6 is running in 32bit mode on the 64bit server.
I'd like to confirm this but I can't seem to find a definitive way to check if IIS6 is in 32bit mode or 64bit mode.
Would someone know the best way to check if IIS6 is in 64bit or 32bit mode?
EDIT: I'm using IIS6
I would like to know whether there is a way to determine programatically if IIS is installed in 32bit or 64bit mode.
View 6 RepliesI've got ASP.NET 4.0 application running on a 64bit OS. IIS is configured to run in 64bit mode (needs to be to support other ASP.NET applications). Is there any way to do this? Oracle doesn't provide a 64bit client as of this writing for .NET 4.0.
View 1 RepliesI have asp.net application which in develop on the 32bit environment it works fine when deployed on the server.But the problem is when we are deploying the application on the 64bit environment it is giving two problem.1) Exception: System.InvalidOperationException: The 'MSDAORA.1' provider is not registered on the local machine."2) Exception: System.Exception: Cannot create ActiveX component.After doing some search people saying that recompiler your appliation as x86 to work on 64bit environment.How can i do that? when can I find the option for that in VS 2005.or
View 1 RepliesHow can I make Visual Studio to use the 64bit compiler (csc.exe/vbc.exe) for an Asp.Net web site?
View 1 RepliesI'm trying to install a 32-bit ASP.NET application onto a 64-bit IIS server running on Windows Server 2008. This is a clean installation of the operating system with no other applications installed.As a prerequisite for our installation, we run the 32-bit version of aspnet_regiis -iIt fails with the following message: The error indicates that IIS is not installed on the machine. Please install IIS before using this tool.Additionally:IIS is definitely installed. The 64 bit version of aspnet_regiis runs cleanly without warnings.€œEnable 32 bit applications" is set to True in the DefaultAppPool's Advanced Settings.
The IIS Metabase and IIS 6 configuration compatibility" component is installed.We have a test VM where this error occurs as well as test VM where both the 32 bit and 64 bit versions of aspnet_regiis run without errors. We've had no luck distinguishing the differences between the two test VMs.We have struggled with this issue for several days to no avail.
I have a website designed using .net 1.1 and upgraded to 2.0. It works fine on Win NT. However, the same application is not working on Win 2003 64 bit server. I read some article on web. Everyone recommends that IIS should run on 32bit mode in win 2003 server if the app was orginated from 32bit. So, I made IIS to run on 32bit mode. The problem is now asp.net config tab is missing in IIS. Is it recommended to convert IIS to run on 32bit in Win 2003 64 bit edition? If so, how do I keep the asp.net configuration tab? Why cant the 32 bit app unable to run on 64bit? Any conversion tool available to upgrade from 32bit to 64bit?
View 2 RepliesMy environment is Windows 7 (64bit), with IIS7. I have a web application that I have hosted remotely, as well as running it locally. The problem is that, when running it locally, I would like to go to the app's address at [URL], but when I do this, the page seems to "Half" render, meaning only some images are shown, styles are not being applied, etc. It is very strange.
However, when running the exact same app in debug mode from Visual Studio (which provides a port, like so [URL]), then the App runs fine. I've looked through all IIS settings, and I am not spotting anything obvious that might be causing this. The default port should be 80 for the app. As far as I know I have left all IIS settings default for the most part, and I've installed every single Windows Feature related to IIS, from the control panel.
Can someone tell me if its possible to run both a 64bit compiled web site and a 32bit compiled website on the same IIS7.5 machine. The core OS would be Windows 2008 R2 64bit. I looked around and can only find how to switch the appPools to 32 or 64. But the question I want answered is can you have one appPool 32bit and another 64bit?
View 1 Repliesi have try to export data to excel using gridview.
I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .
[Code]....
I need to set the exported excel file column format to TEXT but find no solution on this.
In the above mentioned article at "[URL]"Â instead of selecting the existed table in dbserver is it possible to create a dynamic database table based upon the structure of the excel file to be loaded??
View 1 RepliesMy code reading a page from pdf file by PDFLib and sending it to client after putting watermark on the image. The problem is w3wp.exe posses is eating more memory in every request, so after using the program times the memory will be full. My Server system is windows xp 64bit.
This is me code:
[Code]....
Also I tried useing: Response.Buffer = False but no usefulness.
We Installed new application in our dedicated server. I struggle with an issue for the last few days. I get 404 no found in all WebResource.axd requests.
I have uninstall and install .net 2.0 - I have .net 3.5 installed as well. using webresource decrypter I found that many JS files, such as WebForms.js generate the erorr.
I check the iis handlers mapping for .axd
I disable http comp.
When i execute the openrowset with OLEDB4.0 in sqlserver2008(64bit),then the following error comes "Microsoft.Jet.OLEDB.4.0" has not been registered"and the query is
Select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
''Excel 8.0;Database='c: est est.xls ';HRD=NO;',
'SELECT * FROM [sheet1$]') SELECT FirstColumnName FROM tablename
How can I export data from a Gridview to excel and once exported the data should be formatted in right to left (arabic) manner. How can I achieve this?
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
We have the requirement to export the data from the grid excel. We can't install the Excel on the server. The excel generated need to be in the printable format. The excel generated needs to have custom headers, footers, repeatble rows, columns and landscape / portrait orientation style.
View 1 RepliesI'm exporting a Gridview to excel. I get all the gridview header and content in excel in addition to that i need to add a header text like report name in header of the excel sheet with line break in header.
I tried the solution in this link [URL] by adding
Table.Caption = "Header Text"
Table.CaptionAlign = TableCaptionAlign.Top
but i get error Reference to a non shared member requires an object reference.
I am exporting a gridview in MS Excel as mentioned in the following link:
[URL]
I want to set orientation of excel pages as landscape. Is there any way to do that? Any header information to be added for file being exported to set orientation of pages as landscape?
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
i have table something like this on click of export to excel i need to save that or export that to excel file .can u plz help me how i can do this.one more thing how i can desing and build that big html table into excel is there any simple way i can do the same
View 1 Replies