Linking Table to ASE400 DB

  • Thread starter Thread starter Kevin Legg
  • Start date Start date
K

Kevin Legg

My company uses an ASE400 Database.
AKA JD Edwards - Worldvision
AKA people soft

I can not seem to link to the tables and get the correct
data. In particular items that are tagged as being binary
data.

Has anyone had any luck linking Access to JD Edwards?

Thanks,
KPL
 
KPL,
It's not possible; you will need to create a Cobol script to retrieve
and convert the data from the AS400.
 
I use JDE and the AS400 the linkage is through an ODBC.
Just make sure that the convert binary is on in the
configuration of the ODBC. PS. I have a data warehouse of
JDE data in MS SQL that I update with Access 2002.
(e-mail address removed) (remove thatsme) and let me
know it goes!
 
Back
Top