[prev in list] [next in list] [prev in thread] [next in thread] 

List:       adsm-l
Subject:    ODBC problem
From:       Valeriano Bassi <Bassi () SSB ! IT>
Date:       1999-08-31 12:24:07
[Download RAW message or body]

Hi there,
I'm not able to use the odbc interface to ADSM on OS390 server (3.1.2.20).
 
After installing the ODBC component (3.1.0.7), defining data source I
open MS excel, create query, select datasource, connect, select columns,
define filters, sort orders, all works fine.
 
 When I decide to give the data back to excel, I get an error msg which
contains just "garbage" (AOU.....).
 
>From Odbcadsm.out:
Exit    ODBCGetResponseBytes() -- respBytesLeft = 0
Exit    ProcessCommandResponse() -- type = ADMOUT_ENDRESP
Enter CheckError().
     : SQLSTATE = 37000
     : Error Message =

ÁÕÙòùñðÅ@É?¥?&??@âØÓ@£????@`@}ÆÙÖÔ}K¡
Exit    CheckError() -- rc = ADMCMDRC_SYNTAX_ERROR
Exit    SQLPrepare()
Exit    SQLExecDirect()
Entered SQLError()
     : SQLSTATE = 37000
     : Error Message = ÁÕÙòùñðÅ@É?¥?&??@âØÓ@£????@`@}ÆÙÖÔ}K¡
Exit    SQLError()
Entered SQLError()
Entered SQLError()

On  the server I can see the following msg:
ANR2017I Administrator ADMIN issued command: DEFINE CURSOR C7fdd0
SQL="SELECT
STATUS.SERVER_NAME, STATUS.SERVER_HLA, STATUS.SERVER_LLA  FROM STATUS
STATUS"
ANR2017I Administrator ADMIN issued command: DELETE CURSOR C7fdd0

ANR2017I Administrator ADMIN issued command: DEFINE CURSOR C7fdd0
SQL="SELECT
STATUS.SERVER_NAME, STATUS.SERVER_HLA, STATUS.SERVER_LLA  FROM STATUS
STATUS"

What's am I doing wrong?
Thanks in advance and best regards.
Valeriano Bassi          bassi@ssb.it
 

[prev in list] [next in list] [prev in thread] [next in thread]