Hi Paul,

Try the 5.1.0.1 ODBC driver. From Excel XP, I am able to use the "Import"
feature as well as the DB query feature (via MSQRY32) to get data into an
Excel spreadsheet.

By the way, even they are not supported, with this version of the driver,
I have had success in connecting via:

DB2 Warehouse Manager

JDBC-ODBC bridge

ActiveState Perl (version 5.005_03, build 522 + roth ODBC driver dated
12-21-1991 from www.roth.net)

Crystal Reports (known to work with earlier TSM ODBC driver versions)

Access XP (probably will be supported this year)

Excel XP (probably will be supported this year)

VBScript (known to work with earlier TSM ODBC driver versions)

Visual Basic 6.0 (using Microsoft ADO Data Control 6.0 SP4 and Microsoft
DataGrid Control 6.0 SP5)

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/05/2002 08:53
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: TSM/ODBC connection not working...



Actually Andy,
I cannot remember what I was trying to do with EXCEL XP.  But, when I
tried
it again I get an application error trying to read location 0x0.  A test
connection works, but I cannot do the OK to open the database.