Sage 100

Hi, I have a customer running SQL Server 2012 and Mas Version 4.4 I understand that 4.4 does not have a 64 bit ODBC driver. Short of Pulling the info in on the 32 Bit driver to a table and then pulling that in with a 64 bit driver to the reporting module, is there possibly anybody here that has worked around this type of issue? I know the obvious answer is upgrade to 2013 but that at this time is not an option for this customer.

George, I'm not sure I understand your objective. What are you trying to accomplish?

We do exactly as you mention (use 32-bit SQL as an intermediary). Alternatively, if upgrading is out of the question, then DSD's SQL Mirroring add-on might help if real-time data is important. (http://www.dsdinc.com/enhancement/sql-mirroring-3/)

Rather than pull data into SQL, you might consider Sage Intelligence. I suspect if they can't upgrade due to cost constants, the DSD option won't be affordable either.

Install at the minimum sage 2013 on that server with just GL. Then install the 64bit odbc. Then you can configure to pull data into SQL using that ODBC driver.

And there is always the free version of PTQ within Access if all else fails....