Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

64 Bit ODBC and Sage 100 ERP (Formerly Sage ERP MAS 90 and 200)

February 1, 2012 by Wayne Schulz

An interesting question was just asked on the MAS 90 LinkedIn Group. One of the users posed the question:

When a customer has 64-bit OS systems, they naturally want to install 64-bit versions of MS Office. All seems fine until one decides to connect to their 32-bit ODBC and are greeted by the “Specified DSN contains and architecture mismatch”. This happened to me – from a 64-bit version of Excel running on a 64-bit OS, selected Data, Other Sources and then selected SOTAMAS90*. (Note the asterisk). Once selected the message displays about the mismatch.

Is there any way around this? It seems that you need a method to tell the 64-bit programs that when they want to use a specific 32-bit ODBC they need to go through SYSWOW64 and call the ODBCAD.EXE. However, I’ve not found any options to force it to the 32-bit ODBC.

 

The short answer is that 64 bit ODBC drivers are not yet available for Sage 100 ERP .

What most users have done is uninstall any 64 bit apps (usually Microsoft Office 64 Bit) and installing their 32 bit versions.

Our 90 Minds Consulting Group has been tracking this issue since August 2011 and have the following feedback:

 

– Might be able to in MAS 5.0 but probably pushed to 5.1
– PVX Plus may have a 64 bit ODBC to offer (for a fee) at some point (I think they’re testing)

The present resolution has been to uninstall 64 bit Microsoft and install 32 bit.

Would gladly welcome updates from anyone with different workarounds.

 

UPDATE: The 64 Bit ODBC Drivers are available from PVX Plus per the following post on the MAS90 LinkedIN group:

 

 

The driver could be installed on select workstations. If a workstation needed both the 32 Bit and 64 Bit they would have to have different DSNs (logical Data set name) in order to have the system identify which driver to use.
To order the driver you can contact sales@pvxplus.com or call us at 1-888-975-7587 and press 1 for sales.If you want to give it a try it can be downloaded from
http://www.pvxplus.com/pgsrvr.pvp?pg=dl_optional
(select the 64 bit version — second from the top). It should work using a key of DEMO for testing.

Share this:

Filed Under: Sage 100 ERP Tagged With: 64-bit, mas200, odbc, Sage 100 ERP, sage100

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Will There Be A Sage Summit for Sage 100 Users in 2022
  • Avalara Outlines Setup for July 1, 2022 Colorado Retail Delivery Fee
  • Sage 100 API Offered by ROI Consulting
  • Sage 100 Paperless Electronic Delivery Via Gmail Requires App Password or OAuth Starting May 30, 2022
  • Best Practices for Sage 100 Security
  • SPS Commerce MAPADOC EDI for Sage 100 2022 Due for June 22, 2022 Release
  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2022 · Parallax Pro Theme on Genesis Framework · WordPress · Log in