Topic Options
#43374 - 10/31/14 06:07 AM ODBC 9.1A service pack
Johnd Offline
Adagio Enthusiast

Registered: 03/20/09
Posts: 25
Loc: Montreal
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 (63 downloads)


Top
#43375 - 10/31/14 06:17 AM Re: ODBC 9.1A service pack [Re: Johnd]
Johnd Offline
Adagio Enthusiast

Registered: 03/20/09
Posts: 25
Loc: Montreal
Further information:

The table names I use are
AL90DMST for the G/L Account Master
AP81BHST for the A/P Transaction History

Top
#43408 - 11/04/14 11:45 AM Re: ODBC 9.1A service pack [Re: Johnd]
Johnd Offline
Adagio Enthusiast

Registered: 03/20/09
Posts: 25
Loc: Montreal
In order to get my application running again I had to revert to using old aliases:

AL90AMST for G/L Account Master
and
AP80AHST for A/P Transaction History

These are not the aliases that the new Data Dictionary Exporter says to use.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 61 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70658 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30