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@VM.MARIST.EDU] On Behalf Of Remco Post Sent: Thursday, April 24, 2014 7:13 AM To: ADSM-L@VM.MARIST.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.p...@plcs.nl +31 6 248 21 622