MS ACCESS to Query Data on an IBM iSeries DB2

[tonybruno]

Hello, I am trying to query data in Access to an IBM iSeries DB2. I have the table linked using the the Client Access ODBC Driver (32-bit) and it shows in Access that the table is linked. My problem is when I double click on the link I get the following error ---- Reserved error (-7778); there is no message for this error. ----- and when I hit the help button I get the following ----Reserved error <Item>; there is no message for this error. (Error 3000) ----- Any help would be greatly appreciated.
Thank you

[sierra7]

Hello, I am trying to query data in Access to an IBM iSeries DB2. I have the table linked using the the Client Access ODBC Driver (32-bit) and it shows in Access that the table is linked. My problem is when I double click on the link I get the following error ---- Reserved error (-7778); there is no message for this error. ----- and when I hit the help button I get the following ----Reserved error <Item>; there is no message for this error. (Error 3000) ----- Any help would be greatly appreciated.
Thank you

Are you sure you have the correct data driver? My experience (connecting Access to Sage Accounts) is that these drivers are very susceptible to 'versions', i.e at both ends of the link. What version of Access are you using?

have you installed it as SystemDSN or a User DSN and does that make any difference?

If you click on the link I would normally expect a dialog box requesting Username/Password, then be able to browse the tables at the other end.

S7