MS Query – Client Access DSN error

pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Drchris
    I was getting that same SQL0901 error returned and "Attributes of value number 2 in field HVR0002 not valid" in my job log file. This fixed it...BUT it doesn't seem right from the AS400 side. In the ODBC data source on the Sever tab I put the library name in the "Library List" box but in the "SQL default Library" box I put my primary physical file name. I also used a fully qualified file name for the physical file in my SQL statement.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following