I always fail while trying to use the odbc interface to adsm/mvs
servers:
After installing the odbc component, defining data source I open ms
excel,
create query, select datasource, connect, select columns (I can select
the rows described in syscat.columns),
define filters, sort orders, all successful.

When I decide to give the data back to excel, I get an error msg which
contains just "rubbish" (AOU.....). On
the server I can see following error msg:

05.01.1999 16:19:50      ANR2017I Administrator ANALYST issued command:
DEFINE
                          CURSOR C80e00 SQL="SELECT ADMINS.ADMIN_NAME,
                          ADMINS.ADMIN_NAME
FROM ADMINS ADMINS"
05.01.1999 16:19:50      ANR2910E Invalid SQL token - '
FROM'.

What went wrong?

When I use a adsm aix server, all works fine.

Thanks in advance...

Roger Hohmann

WestLB
Division: 009 Services
Abteilung: 001-80633
Herzogstra?e 15
D - 40217 Dusseldorf
Tel.: +49211 826 8155
mailto:roger_hohmann AT westlb DOT de