Missing fields when using ODBC to AS400

[rjd2003]

Good afternoon from Holland!

My problem is: When using an ODBC link from MS Acces to an AS400 database I miss several fields in some tables. These fields are visible when using 'filetransfer' in AS400 itself.

For example: a table has 10 fields A1 - A10. Via file transfer all fields can be found, through ODBC it can occur that for example A3 and A7 are not in the table.

Who knows why this is and how it can be solved.

Thanks in advance

Robert

 

[kuhlkmk]

Hello - did you ever find a solution to this? My co-worker is having the same issue with his ODBC connections through Crystal Reports. Thanks!