ODBC Connection - Office 365 / SA50v2016

Posted By CarlHaase over 4 years ago

Good Afternoon,

I have been reading a lot of posts and I don't think this will exactly duplicate some of those.

After a lot of reading on how to connect our Sage50, I have taken the steps to ensure that I have 'third party' access rights, and when I go in to ODBC32, under User DSN I can see and successfully 'test' the connection (Sage 50: Company 2019.sai) but I am stuck when I go to Excel. I am using the following method;

1. Data --> Get Data --> From Other Sources --> From ODBC

2. Select; Sage 50: Company 2019.SAI from the dropdown list

I get the following error;

Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)"

I have tried to search for some solutions to this with no success. Is this now a limitatation because I am using Office 365 trying to access a 32bit Database?

Also, if we upgrade to SA50 2019, does anyone know if this is a 64bit version or would the upgrade help us out of this?

0 Richard S. Ridings over 4 years ago

Sounds like your Excel is installed in 64-bit mode. I believe you should be using the 32-bit version of Office. You can check the MS forums to see some messages about using the 64-bit version of Office. From what I have read MS recommends using the 32-bit version if you are trying to be compatible with other programs. There might be some setting for compatibility but I have never used the 64-bit version so I have had no need to go look for it.

From what I have read, exceedingly large datasets is about the only reason to use the 64-bit version of Excel. There may be other reasons for other products.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

ODBC Connection - Office 365 / SA50v2016

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING