ADSM-L

[ADSM-L] db2 odbc

2014-04-24 07:14:45
Subject: [ADSM-L] db2 odbc
From: Remco Post <r.post AT PLCS DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 24 Apr 2014 13:12:50 +0200
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

<Prev in Thread] Current Thread [Next in Thread>