Question

MS Query - Client Access DSN error

Microsoft Office, UDB for iSeries/i5

I'm receiving SQL0901 error when I establish a connection through MS Query to the 400. The job log failure is QQQISVSU (level 40) stating "Attributes of value number 2 in field HVR0002 not valid" I've disabled query wizard in hopes that the SQL request would not be made and it gives the same error.

I'm not getting any help from MS because they consider it a ODBC driver problem. I can't find anything referencing this on IBM's support site either.

This started happening when the 400 OS was upgraded to V5R3. I'm using MS Office 2000 on Win XP Pro. I've uninstalled and re-installed Office and Client Access and loaded the appropriate service pack.

This is a guess. Check what version of MDAC (Microsoft Data Access Components) the AS400 upgrade recommends. The most recent is 2.8. It may be the solution. Sometimes a non-MS vendor supports a specific version like 2.6 or 2.7. All of these can be downloaded from the Microsoft web site.