We have a Excel spreadsheet that connects to Sage via a vba odbc connection (Username and Password *'d)
Active7 years, 1 month ago
ODBC Drivers for Microsoft Access, dBase, Excel, Paradox, and Others.; 2 minutes to read; In this article. The topics in this section were previously (Windows 7 and earlier) displayed when you clicked F1 in the ODBC Data Source Administrator dialog box for the Microsoft SQL Server ODBC Driver.
This connection works fine on our 32-bit windows xp computers with office 2010, but not on the new windows 7 64-bit computers running office 2010 32-bit.
When I open the odbc32 in the syswow64 folder the system DSN is installed. Does anyone have any work around for this or a way to connect without accessing the systems DSN (DSN-Less)?
Jamie
migrated from programmers.stackexchange.comAug 21 '12 at 14:59
This question came from our site for professionals, academics, and students working within the systems development life cycle.
1 Answer
I suspect this has something to do with the executable being stored in
syswow32/ or syswow64/ .
I've never used Sage, but I previously had an issue with MyODBC driver on 64b system, the resolution here might help you:
for win 64b users (XP, win7), in order to access your MyODBC driver (or any other DB driver), you need to run the Data Sources from
%windir%SysWOW64odbcad32.exe .
To make the change permanent, you can add a new Data Sources icon in you Control Panel (must do this from the explorer as it will prompt you for confirmation), name it Data Sources x64, and point it to
%windir%SysWOW64odbcad32.exe
for the full article, see here.
fdufffduff
2,48311 gold badge2121 silver badges3131 bronze badges
Active4 years, 9 months ago
using ASP.NET I need to update an excel template.
Our server is running Windows 2008 in 64 bit mode.
I am using the following code to access the excel file:
IF the application pool is set to Enable 32 bit applications the code works as expected; however the oracle driver I am using fails as it is only 64 bit.
If Enable 32-bit applications is set to false the excel code fails with the error:
Data source name not found and no default driver specified
Any suggestions?
5 Answers
The Microsoft Office team has just released a 64-bit driver
Microsoft release a 64bit OLEDB FOR ODBC in 2008/04/04http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&DisplayLang=en
Excel Odbc Driver Windows 7 Ultimate
Now you should able to run everything 64bit, can u try it and let us know the result and personally I think Microsoft should release a 64bit Jet Oledb 4.0, if the development team has no time to do it then just put it in codeplex.com and let other programmers do it.
Excel Odbc Driver Windows 7 Free
There is also 2010 Office System Driver Beta: Data Connectivity ComponentsLink which has allowed us to open Excel 2007 (XLS) from a 64bit environment.
Owner's Guides and Manuals are viewable on any computer or device with. 2011 honda pilot service manual pdf. These manuals require a valid VIN and mailing address.To purchase printed manuals, you can or contact:Helm Incorporated(800) 782-4356M-F 8AM – 6PM ESTDelivery time is approximately five weeks. If your vehicle is equipped with a navigation system, a navigation manual with detailed instructions, settings, and other information is also available.A printed Owner's Manual, Navigation Manual, and Warranty Booklet are complimentary to the first registered owner, up to six months after vehicle purchase. These files contain detailed information about your vehicle, and can be downloaded, searched, and printed.The Owner's Guide provides a quick how-to on basic functions and features.The Owner's Manual explains the various features and functions of your Honda, offers operation tips and suggestions for vehicle care and maintenance, provides specific details on safety systems, and includes comprehensive technical specifications.
This download will install a set of components that can be used by non-Microsoft Office applications to read data from Microsoft Office 2010 Beta files
Excel Odbc Driver Download
Our connection string
There are no office drivers for 64bit released.
The (currently) last post at this link:MSDN Forum details a cumbersome and ugly workaround. You could also replace the Windows Service with a COM exposed assembly, if you wish. Still ugly though. :)
Windows 7 Odbc Driver
Install the 32-bit Oracle driver and enable 32 bit applications?
Not the answer you're looking for? Browse other questions tagged excel64-bitodbcwindows-server-200832-bit or ask your own question.Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |