Last post Feb 10, 2010 05:53 AM by news4naeem
Jan 19, 2010 05:50 AM|news4naeem|LINK
I am using Interp.excel.dll to import the data and OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=3;\""); to export the data. But I am unable to do it.
The same is working perfectly in 32bit server but it is not working in 64 bit server.
I am using Windows 2003 standard x64 bit edition with sp2. I want IIS to run only in 64 bit mode. Is there any work around so that I can use the same.
Thanks & Regards,
Jan 19, 2010 04:23 PMemail@example.com|LINK
Don't mark your post as resolved if it isn't, otherwise nobody will answer. Also, if you need help, you need to give a better description of the problem than "I am unable to do it."
Jan 20, 2010 01:50 PM|news4naeem|LINK
Hey sorry. It was done by mistake and by leaving "I am unable to do it." phrase you can understand what I have posted.
k anyways I will explain it once again.
I am using Jet 4.0 OLEDB driver to export the data from DB to excel. The problem is Jet 4.0 driver is compatible with only 32 bit OS(If I am not wrong) but I am using 64 bit OS. I even installed the driver mentioned in the below link.
I have also registered the oledb dll in "common files" and "system32" folder but still I am getting the error. "Microsoft Jet 4.0 driver is not registered".
However, I am able to run the same by enabling32bitapplication on 64 in IIS 6.0 but after I do that the whole application is running in 32bit mode (Even though the setup is compiled in 64bit mode). I want the application to run in 64 bit mode so that I can
use the features of the 64bit processor.
thnks & regards,
Feb 10, 2010 05:53 AM|news4naeem|LINK
Any replies plz...