Remco, 

I don't know if this will help you, but I had a customer report to me that the 
old TSM V5 ODBC driver still works with V6.
Can't say for sure as I haven't used it personally.
(I know the book says it is not supported.)

Wanda

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Remco Post
Sent: Thursday, April 24, 2014 7:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] db2 odbc

Hi all,

I'm working on a simple excel for billing purposes (as a first step). I've 
installed the DB2 Data server driver ODBC (and CLI) package. And have managed 
to configure both a user DSN and a file DSN, but not a system DSN, which is 
what I prefer, because other people will have to be able to generate the 
monthly report as well. The file DSN is giving me headaches every time I try to 
refresh the table, for some reason ms query and/or excel think a sql server is 
a better solution than db2 and want to connect me to such a thing. The user dsn 
seems to work better (though I had to tweak it somewhat to make it work).

Has anyone succeeded in creating a system DSN for a ODBC connection to the DB2 
used by TSM and make it work?

-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622