ADSM-L

ODBC problem (on non english systems)

1999-08-31 09:36:04
Subject: ODBC problem (on non english systems)
From: Winfried Heilmann <Winfried.Heilmann AT INFRACOR DOT DE>
Date: Tue, 31 Aug 1999 15:36:04 +0200
Hi,

are you using EXCEL 97 SR2? IBM told me that I have  to use that Level.
Problems are appearing with SR1. But I haven't tried it with SR2.

I have also received the following mail from IBM.

No, unfortunately we can not support the ODBC driver on non-English
systems for this time. In the past, we allowed the ODBC driver to be
installed on non-English systems, and the installation caused
problems for a lot of users. I am investigating what we need to do
to support this, but for now it will remain a restriction. I can not
say when this will get fixed. I apologize that I do not have better
news than this.

Maybe that can help or explain the problems


Regards Winfried




---------------------- Weitergeleitet von Winfried Heilmann/Degussa AG/DE on
DE on
31.08.99 14:45 ---------------------------


ADSM: Dist Stor Manager <ADSM-L AT VM.MARIST DOT EDU> on 31.08.99 14:22:55
Bitte antworten an ADSM: Dist Stor Manager <ADSM-L AT VM.MARIST DOT EDU> @ 
INTERNET
An: ADSM-L <ADSM-L AT VM.MARIST DOT EDU> @ INTERNET
Kopie:
Thema:  ODBC problem

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 AT ssb DOT it



<Prev in Thread] Current Thread [Next in Thread>