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
|