We are using ODBC to access tables from Payables and Ledger. Since installing the ODBC 9.1A (2014.09.22) Service Pack we can no longer access the GL Account Master and the Payables Transaction History tables. It is as if the tables no longer exist (or else the names have changed). All other tables we access with ODBC are working fine.

In the DSN we are using short names, and I used the /odbc switch to export the Data Dictionary and confirmed the table names are correct. I have not made any changes to the script I use for the extraction of data, and it worked fine before the recent service pack.

We have:
Lanpak 9.2A (2014.07.24)
Ledger 9.1A (2014.02.21)
Payables 8.1F (2013.08.26)
ODBC 9.1A (2014.09.22)

Any ideas?


Attachments
adagiodsn.jpg (62 downloads)