DOCUMENT:Q179921  13-JUN-2001  [sna]
TITLE   :Error -204 When Using the STARSQL32 Driver
PRODUCT :Microsoft SNA Server
PROD/VER:WINDOWS:3.0,3.0 SP1,3.0 SP2,4.0
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft SNA Server, versions 3.0, 3.0 SP1, 3.0 SP2, 4.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

The following error message appears when you try to access a table on the AS/400
using the StarSQL ODBC driver that ships with SNA Server:

   "[Starquest] [StarSQL ODBC Driver] [DB2/400] object QSYS2.SYSKEYS type *table
   not found [#-204]"

CAUSE
=====

To connect to an AS/400 V3R1 system using the STARSQL32 ODBC driver, a package
called BASE SUPPORT must be loaded on the AS/400. BASE SUPPORT provides several
tables in the QSYS2 collection, including SYSKEYS, SYSCOLUMNS, SYSINDEXES, and
so on, which are required for use with the STARSQL32 ODBC driver.

RESOLUTION
==========

To resolve the problem, do the following:

1. To check for BASE SUPPORT on the AS/400, log on as QSECOFR.

2. From a command line, type

   GO LICPGM

   Then press ENTER.

3. Select option 10 to view license programs. Look for BASE SUPPORT.

4. Load BASE SUPPORT on the AS/400 from the OS media. Adding BASE SUPPORT
   requires an initial program load (IPL) of the AS/400.

MORE INFORMATION
================

This problem can arise on older AS/400s when they are upgraded from previous
releases of OS/400 to V3R1. When upgrading, only the components that were
installed with the previous version will be upgraded to V3R1. BASE SUPPORT was
not required on previous versions of OS/400 to work with the StarSQL ODBC
driver.

The third-party products discussed here are manufactured by vendors independent
of Microsoft; we make no warranty, implied or otherwise, regarding these
products' performance or reliability.

Additional query words: database

======================================================================
Keywords          :  
Technology        : kbAudDeveloper kbSNAServSearch kbSNAServ300 kbSNAServ400 kbSNAServ300SP1 kbSNAServ300SP2
Version           : WINDOWS:3.0,3.0 SP1,3.0 SP2,4.0
Issue type        : kbprb

=============================================================================

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.

Copyright Microsoft Corporation 2001.