Sage 2012 ODBC

There are bugs in the ODBC driver for v2012 and there is a specific update here: https://support.sage.co.uk/default.aspx?page=22&did=5f12052a-4023-441d-8...

Some of the issues are listed here:

Issue and How to Resolve:

1) Problem with returning data in MS Access if the data is on a network (This problem only affects MS Access, any other interfaces into the ODBC driver are not affected.)
The symptoms would be when you first query would return all data, second attempt at the same query would return partial or none of the data. Some rows may be populated with “Deleted”.

Resolve
• Click Start
• Run
• Regedit and enter
• Find HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SageLine50v18
• Add String Value
o Name = ThresholdToFileCopyTime
o Value Data = 1000000

2) Category name variable displays incorrect category name after installing update 3.
3) The INVOICE.COURIER_NAME variable displays incorrectly after installing update 3.
4) Unable to link ODBC to the Access database to update tables update 3.
The problems would occur when you run reports that are dealing with “Category” and the “Invoice.Courier_Name” field. “Column Not found” or when trying to access tables via MS Access

John

It was so nice to see an answer to the problem. I hit that bug and gave up. Now I type the numbers in instead of linking and found it didn't actually take very long to type, and it made me look closer at the results!! But I'm getting old and crotchety and so fed up of constantly reworking stuff to make it work again. So just ignore me!!!

Hi Jason

I have used ODBC successsfully and it works OK. I woudl suggest you check the directory path onthe ODBC entry and then perhaps do a couple of single table queries first before looking at the existing query. Once thsi is all OK, you may want to use MS QUERY to see if it retrieves the data based on the existing query.

Hope that helps.