|
|
Rank: Member
Joined: 7/12/2004
Posts: 2
Location: IL
|
Hello,
I have installed a trial DbSpy version on my Windows XP machine in order to check how does it work with DB2. I have spent a lot of time looking for DB2 ODBC driver. When I found and installed it, I still cannot add a DB2 data source, since there is no place to enter a remote server name and (since there is no DB2 client) there is no database catalog.
I tried to connect to a MS SQL Server and there is no problem connecting to it.
Does DatabaseSpy require DB2 client to be installed on the same machine? Thank you.
|
|
Rank: Advanced Member
Joined: 8/17/2004
Posts: 149
Location: NL
|
ODBC drivers are specific for the different databases. So for DB2 you will need an ODBC driver for DB2.
DB2 client comes with a DB2 ODBC driver, so you will need DB2 client.
There might be some third party drivers available. You can do a search.
And if DB2 is on an iSeries you could use the iSeries Access ODBC driver.
|
|
Rank: Member
Joined: 7/12/2004
Posts: 2
Location: IL
|
Thank you, mpcsmits. But of course I've got the IBM DB2 ODBC and CLI driver from an IBM DB2 support pages (but later have found it on one of the DB2 installation disks). The problem is that I don't want to install the DB2 client (pretty hefty piece of software) for ODBC driver only on this particular computer whose only connection to DB2 is DatabaseSpy. Is there a 'lighter' solution?
Back to my initial question: do I have to install the DB2 client to use DatabaseSpy with DB2?
|
|
|
guest |
