Sage 50 ODBC Connection

Question

I try to connect MS Excel to Sage file via ODBC. I got following message: 
 
 Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)" 
 
 I am using Windows 10 64-bit. MS 365 Excel 64-bit. 
 Some people said to add "pervasive odbc engine interface" to the ODBC-32bit, but I do not find the "pervasive odbc engine interface" on my list. 
 
 I am wondering if there is way to solve the issue. 
 
 Alvin

Richard S. Ridings · Accepted Answer

alvinmwl@gmail.com said: I installed the 64-bit MySQL ODBC 5.2.4a driver in my company, 
 I'm confused by this. Are you talking about your Sage 50 company file or just your business in general? 
 The drivers are for the computer you are operating on, not the server. When I installed the driver this morning, the Platform column in the images you posted indicated 32/64bit instead of just 32bit. 
 Do you see the MySQL driver under the Drivers tab in the 64bit ODBC Administrator (second image). 
 The image below shows the file I downloaded this morning. More current versions may work as well but I decided to keep with the base version released with Sage 50.

Richard S. Ridings · Answer

Unfortunately, I can't help much at a distance as I do not have a suitable environment like your's to test with. 
 The basic steps to test would be to download the 64-bit 5.2.4 ansi driver from the MySQL website. This is the same level version as the 32-bit version you currently have installed. 
 Install it. 
 Use that 64 bit ODBC Administrator you found on your computer to set up a DSN for your Sage 50 database. 
 Connect to it from Excel. 
 
 I can't guarantee this will work but short of reinstalling your Office as 32-bit, it is the easiest option. It is only based on info I have read on various MySQL website forums. I do know the Excel 32-bit version will connect ok with the ODBC drivers currently installed on your system but have never had a system setup like your's to test it with 64-bit drivers. 
 If you want to contact me off forum you can find my email address in my profile here on this site. I might be able to help you out later this week. I am not a Sage employee and this does go beyond the free help users get on this forum and would be considered part of my consulting services. We can discuss this off forum if you wish.

Sage 50 Canada

Sage 50 ODBC Connection

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING