Error Performing Query, Incorrect Userid or Password

Last reviewed: April 17, 1997
Article ID: Q148960

The information in this article applies to:

Microsoft SNA Server for Windows NT, versions 2.11, 2.11.sp1, and 3.0
Microsoft Internet Information Server version 1.0

SYMPTOMS

When you run an IDC script that connects to an AS/400 using the StarSQL ODBC driver that is included with SNA Server version 2.11, you may get the following error message from your web browser.

   Error Performing Query

   * [State=28000][Error=0][Star Ware][StarSQL ODBC Driver] Incorrect
     userid or password

CAUSE

This message occurs when you incorrectly type the Username: and Password: in the IDC script.

These symptoms can also be caused when you type the correct password in the incorrect case.

RESOLUTION

Make sure to capitalize the Username: and Password: fields in the IDC script file.

MORE INFORMATION

When you troubleshoot this problem, you will notice:

The user is able to receive a sign-on screen from the AS/400 after typing the same User ID: and Password in the session sign-on when he or she uses the 5250 applet.
The user is able to query the AS/400 database correctly when he or she uses the MS Query tool after typing the same User ID and Password when selecting the datasource.

The 5250 applet and the MS Query tool capitalize the session signon User ID and Password. In the case where you are typing the Username and Password in the IDC script, neither the Internet Information Server (IIS) nor the StarSQL ODBC driver capitalize the Username and Password. This can result in the error message above being returned to the browser.

Additional query words: prodsna
Keywords : kbnetwork snaodbc
Version : 2.11 2.11.sp1 3.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.