By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

DB2 UDB 8.2 for Linux and the ODBC-driver

P: n/a
Hello All,

Whether supports DB2 UDB 8.2 FP7 for Linux the ODBC-driver ?
If yes, whether that enters this driver into delivery DB2 UDB 8.2 FP7
for Linux ?
If it is possible, bring please an example of customization of the
ODBC-driver for DB2 under Linux.

--
Best Regards, Stalker

Origin: The History is Dead
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Tolik Gusin wrote:
Hello All,

Whether supports DB2 UDB 8.2 FP7 for Linux the ODBC-driver ?
If yes, whether that enters this driver into delivery DB2 UDB 8.2 FP7
for Linux ?
If it is possible, bring please an example of customization of the
ODBC-driver for DB2 under Linux.


Hello Tolik.

I realise you aren't a native English speaker (Ukraine ?) so hopefully you
can understand the following -

The ODBC driver for DB2 on Linux is all within the db2cli (CLI is bigger
than ODBC, but ODBC is a subset of it).

You will need to install the unixODBC package. You don't say which Linux
distro you are running, so positions of files etc may vary. I'm using SuSE
Pro 9.3 and my config files are under /etc/unixODBC. The files are -

odbcinst.ini (this defines the driver details)
============

[DB2]
Description = DB2 Driver
Driver = /opt/IBM/db2/V8.1/lib/libdb2.so
Driver64 =
Setup =
Setup64 =
UsageCount =
CPTimeout =
CPReuse =
FileUsage = 1
DontDLClose = 1

odbc.ini (data sources : individual databases)
========

[DBAIR001]
Description = Aircraft Database
Driver = DB2

[FSITEST]
Description = FSI Test
Driver = DB2

The data source name (in square brackets) relates to the cataloged database
alias name. The "Driver = DB2" points back to the [DB2] definition on
odbcinst.ini.

The graphical ODBC admin tools on SuSE 9.3 didn't seem to work for me, so I
had to configure this manually, using some docs at http://www.unixodbc.org
(which I found by searching on Google for "ODBC DB2"

HTH

Phil

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.