Adding ODBC Connections for Excel. A named range is a set of columns and rows that have a unique name within an Excel file. For example, the next display shows two named ranges. One range (range1) is selected. You can use ODBC DSN connections to read named ranges in an Excel spreadsheet. Each Excel file can have multiple named ranges (tables).
using ASP.NET I require to update an excel template.
Our server is working Home windows 2008 in 64 bit mode.
I have always been making use of the following code to gain access to the excel document:
IF the program pool is usually arranged to Enable 32 bit applications the code functions as expected; however the oracle driver I are using fails as it will be only 64 bit.
If Enable 32-bit applications is certainly arranged to false the excel program code does not work out with the mistake:
Data source title not discovered and no default driver stipulated
Any suggestions?
5 Answers
Thé Microsoft Workplace team provides simplylauncheda64-bit driverMicrósoft release a 64bit OLEDB FOR ODBC in 2008/04/04http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059bamp;DisplayLang=en
Now you should able to run everything 64bit, can u try it and allow us understand the result and personally I believe Microsoft should discharge a 64bit Jet Oledb 4.0, if the growth team provides no period to do it after that just put it in codepIex.com and allow other developers perform it.
Thére will be also2010 Office System Motorist Beta: Data Connectivity PartsHyperlink which provides allowed us to open up Excel 2007 (XLS) from a 64bit environment.
This downIoad will set up a collection of elements that can be used by non-Microsoft Office programs to read information from Microsoft Office 2010 Beta files
Our link chain
Thére are usually no office motorists for 64bit launched.
The (currently) last post at this link:MSDN Forum points a troublesome and ugly workaround. You could furthermore replace the Windows Provider with a COM exposed assembly, if you desire. Still unattractive thóugh. :)
lnstall the 32-bit Oracle driver and enable 32 little bit applications?