Data descriptor mismatch. SQLSTATE: HY000, SQLCODE: -292

[Andrew Burgher]

Hi all,

Using HIS 2006 (Microsoft ODBC Driver for DB2) to connect to a DB2 MVS
instance we encounter the following error:

<eb1>Data descriptor mismatch. SQLSTATE: HY000, SQLCODE: -292
State:S1000,Native:-292,Origin:[Microsoft][ODBC DB2 Driver]</eb1>

We're able to successfully connect - but on some machines we consistently
get the above error when attempting either the 'Sample Query' in the HIS Data
Access Tool, or a simple query against our DB2 database.

Any chance others have encountered this and possible know a workaround or fix?

Thanks in advance,
Andrew

[t***@gmail.com]

Post by Andrew Burgher
Hi all,
Using HIS 2006 (Microsoft ODBC Driver for DB2) to connect to a DB2 MVS
<eb1>Data descriptor mismatch. SQLSTATE: HY000, SQLCODE: -292
State:S1000,Native:-292,Origin:[Microsoft][ODBC DB2 Driver]</eb1>
We're able to successfully connect - but on some machines we consistently
get the above error when attempting either the 'Sample Query' in the HIS Data
Access Tool, or a simple query against our DB2 database.
Any chance others have encountered this and possible know a workaround or fix?
Thanks in advance,
Andrew

Hi Andrew, this issue is a HIS2004 Reminiscence, but is very simply to
solve.
You only have to check in the affect machines..panel control\regional
settings\advanced, the entry of the code-page conversion table (egs.
20280 EBCDIC Italian), be sure to match with the CCSID specified in
the connection string.

with regards
Lawerence

[Andrew Burgher]

Hi Lawrence,

Your suggestion worked. Thank you.

In our environment the connection string specified CCSID=37 (IBM ECBDIC -
U.S./Canada). On the working machines this code-page was 'checked' in the
Advanced tab of the 'Regional and Language Options' control panel, but on the
non-working machines it was 'unchecked'. By 'checking' code-page 37 we can
now run the 'Sample Query' command in the HIS 2006 'Data Access Tool', and
are able to progress.

Regards,
Andrew

Post by t***@gmail.com

Post by Andrew Burgher
Hi all,
Using HIS 2006 (Microsoft ODBC Driver for DB2) to connect to a DB2 MVS
<eb1>Data descriptor mismatch. SQLSTATE: HY000, SQLCODE: -292
State:S1000,Native:-292,Origin:[Microsoft][ODBC DB2 Driver]</eb1>
We're able to successfully connect - but on some machines we consistently
get the above error when attempting either the 'Sample Query' in the HIS Data
Access Tool, or a simple query against our DB2 database.
Any chance others have encountered this and possible know a workaround or fix?
Thanks in advance,
Andrew

Hi Andrew, this issue is a HIS2004 Reminiscence, but is very simply to
solve.
You only have to check in the affect machines..panel control\regional
settings\advanced, the entry of the code-page conversion table (egs.
20280 EBCDIC Italian), be sure to match with the CCSID specified in
the connection string.
with regards
Lawerence