Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You receive SQL Error -514 when you link to a table that has more than 10 records

You receive SQL Error -514 when you link to a table that has more than 10 records

View products that this article applies to.

Symptoms

You are using a linked table in Microsoft Access with the Host Integration Server (HIS) 2000 ODBC Driver for DB2. You connect through TCP/IP to an IBM mainframe OS390 system, and you receive the following error message if there are more than 10 records stored in the table:
SQL Error -514 has occurred. Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State.
This problem occurs only when you connect to DB2 on a mainframe host system. The problem does not occur when you connect to DB2 on an AS/400 system.

↑ Back to the top

Cause

Because of the way that Access interacts with linked tables, if there are more than 10 records stored in a table, the ODBC Driver for DB2 may send a Distributed Data Management (DDM) Close Query (clsqry) command to the host system in certain situations. When clsqry is sent to DB2 on a mainframe, the current SQL statement is always unprepared. When Access tries to fetch the next bulk of stored records from the linked DB2 database, the ODBC Driver for DB2 will issue a DDM Query Answer Set Data (qrydta) command. This command fails because it does not have a PREPARE statement in front of it.

↑ Back to the top

Resolution

To resolve this problem, obtain the latest service pack for Host Integration Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
328152 How to obtain the latest Host Integration Server 2000 service pack
The English version of this fix must have the following file attributes or later: 
   Date         Time    Version     Size       File name
   --------------------------------------------------------
   25-Apr-2002  15:37   5.0.0.836   258.320    mseidrda.dll
   25-Apr-2002  15:37   5.0.0.836   876.816    mseidb2d.dll
   25-Apr-2002  15:37   5.0.0.836    78.096    mseidb2c.dll
Note Because of file dependencies, the most recent fix that contains the preceding files may also contain additional files.

↑ Back to the top

Status

Host Integration Server 2000

Microsoft has confirmed that this is a problem in Host Integration Server 2000. This problem was first corrected in Host Integration Server 2000 Service Pack 1.

↑ Back to the top

More information

If you turn on ODBC tracing on the affected computer, you may see a trace output similar to the following: 
MSACCESS        734-978	EXIT  SQLPrepareW  with return code 0 
(SQL_SUCCESS)
		HSTMT               08641790
		WCHAR *             0x0D361F38 [      -3] "SELECT 
KEY,TEXT,INFODATA  FROM YBI.IMAGES  WHERE KEY = ? OR KEY = ? OR KEY = ? 
OR KEY = ? OR KEY = ? OR KEY = ? OR KEY = ? OR KEY = ? OR KEY = ? OR 
KEY = ?\ 0"
		SDWORD                    -3

MSACCESS        734-978	ENTER SQLBindParameter 
		HSTMT               08641790
		UWORD                        1 
		SWORD                        1 <SQL_PARAM_INPUT>
		SWORD                       99 <SQL_C_DEFAULT>
		SWORD                        4 <SQL_INTEGER>
		SQLULEN                   10
		SWORD                        0 
		PTR                0x0D3621C4
		SQLLEN                     0
		SQLLEN *            0x0D3621C0
..........and so on
MSACCESS        734-978	ENTER SQLFetch 
		HSTMT               08641790

MSACCESS        734-978	EXIT  SQLFetch  with return code 100 
(SQL_NO_DATA_FOUND)
		HSTMT               08641790

MSACCESS        734-978	ENTER SQLFreeStmt 
		HSTMT               08641790
		UWORD                        0 <SQL_CLOSE>

MSACCESS        734-978	EXIT  SQLFreeStmt  with return code 0 
(SQL_SUCCESS)
		HSTMT               08641790
		UWORD                        0 <SQL_CLOSE>

MSACCESS        734-978	ENTER SQLBindParameter 
		HSTMT               08641790
		UWORD                        1 
		SWORD                        1 <SQL_PARAM_INPUT>
		SWORD                       99 <SQL_C_DEFAULT>
		SWORD                        4 <SQL_INTEGER>
		SQLULEN                   10
		SWORD                        0 
		PTR                0x0D3621C4
		SQLLEN                     0
		SQLLEN *            0x0D3621C0
.........and so on
MSACCESS        734-978	ENTER SQLExecute 
		HSTMT               08641790

MSACCESS        734-978	EXIT  SQLExecute  with return code -1 
(SQL_ERROR)
		HSTMT               08641790

		DIAG [     ] [Microsoft][ODBC DB2 Driver][DSP1] A SQL error 
has occurred.  Please consult the documentation for your specific DB2 
version for a description of the associated Native Error and SQL State. 
(-514) (means Cursor not in prepare state)

MSACCESS        734-978	ENTER SQLErrorW 
		HENV                086414F0
		HDBC                08641598
		HSTMT               08641790
		WCHAR *             0x0012D50C (NYI) 
 		SDWORD *            0x0012D558
		WCHAR *             0x03761730 
		SWORD                     4095 
		SWORD *             0x0012D548

MSACCESS        734-978	EXIT  SQLErrorW  with return code 0 
(SQL_SUCCESS)
		HENV                086414F0
		HDBC                08641598
		HSTMT               08641790
		WCHAR *             0x0012D50C (NYI) 
 		SDWORD *            0x0012D558 (-514)
		WCHAR *             0x03761730 [     188] "[Microsoft][ODBC 
DB2 Driver][DSP1] A SQL error has occurred.  Please consult the 
documentation"
		SWORD                     4095 
		SWORD *             0x0012D548 (188)
DDM commands are defined by the Open Group. The DDM technical standard stands for "Distributed Data Management Architecture."

↑ Back to the top

Keywords: KB321872, kbhostintegserv2000sp1fix, kbhostintegserv2000presp1fix, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 321872
Revision : 2
Created on : 12/18/2012
Published on : 12/18/2012
Exists online : False
Views : 415