Hello, In our application we have to open various Office file such as word, excel etc. We are sending the files to the client using response, content type etc. When sending the content we are specifying the content type i.e. MIME type accordingly. Now, recently the content is of new Office 2007 type i.e. docx, docm, xlsx, xlsm, pptx. The content is sent accordinlgy from the server with the new MIME types, however we are unable to open the files in the client machines. We tested the same on client machines that has Office 2007 installed and everything works as expected. Now we are testing the same on client machines that have only Office 2007 compatability pack installed. But this way it does not work and is providing options, find, save and cancel instead of open, save and cancel. Can we open files using the compatbility pack alone? Are we missing something, please let us know.

gauthee

Hello, We have an application that is developed in Java. This application internally uses contenta tool to save files such as doc, xls, pdf, etc etc. Using the application we save various files. The contenta tool's methods and classes are used to save the files internally in the oracle database and maintains history of the files too. Now, we are planing to migrate the application into .NET and replace the contenta tool. Are there any tools that go well with .NET to save various files and maintain history of the files. Sharepoint is not our option. PLease suggest

gauthee

Chris, You can try creating a usercontrol. Create a usercontrol using all your appropriate styles. Later you can use this control in all your web pages by registering the user control in those pages!

gauthee

Refer this: http://www.c-sharpcorner.com/UploadFile/avi_sanjay/JSWebService12312005110538AM/JSWebService.aspx[^]

gauthee

Hi All, When an application is being accessed at the same time using multiple tabs in IE7 the session id is being shared and this leads to some problems. Let us say when i opened the application in the first tab the session id is abcdsa1234.... then i opened the same application in the second the session id is same i.e. abcdsa1234..... This leads to several issues. A solution to this would be making the sessions cookie-less, this way when accessing the same application using multiple tabs different session ids would be created however the session id values are shown in the URL and this for sure is a security threat! Are there any other ways to handle session ids when accessing the application using multiple tabs or multiple windows??

gauthee

Hi, I have developed a webservice which comprises a sinlge web method. This web method is used for document conversion. The return type of the web method is bytes. The web service is consumed in my web application and everything works fine. But when my colleague is trying to consume the same web service in my system to his web application an error is being thrown. My colleague added the web service to his application using the VS IDE. When accessing the web method after creating an object for the web service the following error is shown: System.Net.WebException: The request failed with HTTP status 404: Not Found. I tried to access the webservice by provinding the URL in IE then it works fine, so what are we missing? Do we have to do any addtional steps when consuming a webservice which is not in the same machine or same domain? Any help is greatly appreciated,

gauthee

Do we have an pre-requistes before creating an excel object for a windows application developed using c#? Is there any sort of memory limitation when creating an excel object. Our application runs fine when few processes are running along with the application, however when the number of other processes are increased then an error is displayed " <b>THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN </b>". The solution to this error is a system restart, when this error occurs you cannot open any existing excel file too! Please note that our application has needed excel objects clean up code. What could be the cause for this error? How to resolve this? Kindly help!

gauthee

Do we have any pre-requistes before creating an excel object for a windows application developed using c#? Is there any sort of memory limitation when creating an excel object. Our application runs fine when few processes are running along with the application, however when the number of other processes are increased then an error is displayed " THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN ". The solution to this error is a system restart, when this error occurs you cannot open any existing excel file too! Please note that our application has needed excel objects clean up code. What could be the cause for this error? How to resolve this? Kindly help!

gauthee

mav, Thanks for the reply! Sorry, if the info provided was unclear, what else you would require to analyze further? The other details are as follows: 1.When the error occurs we no longer can open an excel file. 2.After the system restart the excel application work. 3.Strangely the error(not enough memory) willnot occur when the number of processes running in my machine are minimal, when i run more applications/processes in my system this exce memory error occurs. 4.all COM objects related to excel are being released(not 100% sure though). we are searching for any excel processes running and then doing the kill process too! Thanks!

gauthee

Hi, We have a windows application developed using c#. We have a process in this application where excel objects are created some data is populated and some calcualtions are done too (used various excel objects like workbook, sheet, range). The required tasks are being executed fine but there are instances where the same tasks fail. An error is being thrown at that time and it is "THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN" The error is pointed to Excel object creation and it shows - "An unhandled exception of type System.Runtime.InteropServices.COMException occurred in application_name.exe" What could be the cause for the error? Please provide some suggestions. Thanks

gauthee

Hi, We have a windows application developed using c#. We have a process in this application where excel objects are created some data is populated and some calcualtions are done too (used various excel objects like workbook, sheet, range). The required tasks are being executed fine but there are instances where the same tasks fail. An error is being thrown at that time and it is "THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN" The error is pointed to Excel object creation and it shows - "An unhandled exception of type System.Runtime.InteropServices.COMException occurred in application_name.exe" What could be the cause for the error? Please provide some suggestions. Thanks

gauthee

hi, i have formed query using several joins. Now that i want the data to be unique, so thuoght of using 'distinct' but it does not seem to help. There is a column named Id in the query and i dont want this to be duplicated hence i gave select distinct(id), ....... but this showed up some error. when using distict it is applying for the entire row, so its checking for each and evry column. Is it possible to use distinct keyword for one or two coulmns instead for the entire row i.e. all columns

gauthee

HI, We have an application which was developed in Java for this we provided a web service using .net this web service basically helps in converting documents to pdf format. Everything works fine however the issue is with anonymous access given to the web service. The client feels it could be a threat and wants us to remove the anonymous access to the web service. On doing so there is no communication betwwen the application and the web service. Question: ON removing anonymous access what are the other steps that i should follow at the application level and at the web service level.

gauthee

Thanks Balaji! the article was helpul however it was just an abstract! Is there some sort of practical example so that it would be easy for us to relate!

gauthee

HI, we have a web service and our application(.net 1.1, C#, oracle) consumes this web service. By default the security(authentication) is given anonymous, now as for security reasons we want to remove this option. So lets say we use Integrated Windows Authentication. Doing so we would get Access Denied 401 error. On searching though it is found that we could pass few credentials and access the web service (this works fine) What are the cons in providing user credentials in the code? What are the steps to be followed to make a web service secure and accessible? Is there a way that a web service can be accessed after removing anonymous access and not providing any credentials in the code?

gauthee

HI, we have a web service and our application(.net 1.1, C#, oracle) consumes this web service. By default the security(authentication) is given anonymous, now as for security reasons we want to remove this option. So lets say we use Integrated Windows Authentication. Doing so we would get Access Denied 401 error. On searching though it is found that we could pass few credentials and access the web service (this works fine) What are the cons in providing user credentials in the code? What are the steps to be followed to make a web service secure and accessible? Is there a way that a web service can be accessed after removing anonymous access and not providing any credentials in the code? Thanks a ton!

gauthee

Hi, We have a wbservice that converts any doucment to pdf format, internally we used novapdf printer driver for the conversion process. The application using the web service works fine with word, excel, txt and rtf formats. HOwever there is a problem with ppt, When trying to upload and convert a ppt document an error is being thrown. What could be the problem? The error is as follows: System.IO.FileNotFoundException: File or assembly name office, or one of its dependencies, was not found. File name: "office" at NovaPDFWebService.ConverterService.PPointtoPDF(String strPath) at NovaPDFWebService.ConverterService.ConvertToPDF(String strPath, String strExtention) in c:\inetpub\wwwroot\novapdfwebservice\converterservice.asmx.cs:line 212 at NovaPDFWebService.ConverterService.ConvertToPDF(String fileName, Int32 fileSize, Byte[] fileBytes) in c:\inetpub\wwwroot\novapdfwebservice\converterservice.asmx.cs:line 131 === Pre-bind state information === LOG: DisplayName = office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c (Fully-specified) LOG: Appbase = file:///c:/inetpub/wwwroot/NovaPDFWebService LOG: Initial PrivatePath = bin Calling assembly : NovaPDFWebService, Version=1.0.2827.34780, Culture=neutral, PublicKeyToken=null. === LOG: Publisher policy file is not found. LOG: No redirect found in host configuration file (C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet.config). LOG: Using machine configuration file from C:\WINNT\Microsoft.NET\Framework\v1.1.4322\config\machine.config. LOG: Post-policy reference: office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/novapdfwebservice/51728cb4/606e3667/office.DLL. LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/novapdfwebservice/51728cb4/606e3667/office/office.DLL. LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/NovaPDFWebService/bin/office.DLL. LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/NovaPDFWebService/bin/office/office.DLL. LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/novapdfwebservice/51728cb4/606e3667/office.EXE. LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporar

gauthee

You have passed more parameters to the stored procedure than required!

gauthee

Pretty old one! I guess you missed the moral that is associated to the story!

gauthee

yes i read somewehere! To display your assembly in the Add Reference dialog box, you can add a registry key, such as the following, which points to the location of the assembly [HKEY_CURRENT_USER\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders\MyAssemblies]@="C:\\MyAssemblies" -- where "MyAssemblies" is the name of the folder in which the assemblies reside. NOTE: You can create the this registry entry under the HKEY_LOCAL_MACHINE hive. This will change the setting for all of the users on the system. If you create this registry entry under HKEY_CURRENT_USER, this entry will affect the setting for only the current user. The link is : http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=1175[^]

gauthee