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