Problems installing unixODBC on Linux 1

[nanvoo]

Hello
Has anyone made any experiences working with unixODBC on Suse Linux 7.1 for PPC? I have downloaded the binaries, configured and made an install. Unfortunately the file ODBCConfig used to configure the DSN (whatever that is) is nowhere to be found. The final goal is to access an Iseries database with an existing iSeries ODBC Driver.
Thanks a lot

Nanvoo

 

[ThJ]

I've got the same problem with Red Hat 7.3.
But I've edited /etc/odbcinst.ini and /etc/odbc.ini with vi to create entries, copied /etc/odbc.ini as ~/.odbc.ini and it works.
I'am able to run isql command.

Actually ODBC works with a remote MySQL DB but I am not able (so far) to run it with a remote NT DB2 DB or a local instance of DB2!

 

[Faroon]

did you guys have to install a client also or just unixodbc?

 

[ThJ]

More than a "client" it is the library used to access the remote DB.
For DB2 I finally installed DB2 Connect which provide ODBC librairies and more.
Actually I don't know how to get the ODBC librairies alone.

Thierry

 

[Faroon]

Ok, I need to connect to a remote DB2 database from my BSD box. What do you guys suggest I do? I installed iODBC and DBI::ODBC module? Are those enough? And is that DB2 Connect a freeware or a trial version? Thanks.

 

[ThJ]

There are some DB2 trial stuff but not sure for BSD OS (check at

http://www6.software.ibm.com/devcon/devcon/cgi-bin/dccustom.cgi)

If you want/can use Java, there is a JDBC connector (needs to be actived on your server) AND the jdbc library is coming when you install DB2 server (look for db2java.zip)

For other connections (Perl, Cobol, ...) using ODBC you need the DB2 ODBC driver for your plateform. e.g. DBI::ODBC (Perl I guess) allows Perl to address an ODBC driver specific for the Database you are targetting through the ODBC channel.

HTH
Thierry

 

[Faroon]

Thanks for the reply. I do have both IODBC (3.0.6) and DBI::ODBC(1.06) installed. Running odbctest gives me a segmentation fault. and using DBI::ODBC with Perl gave me all sort of problems. I'm guessing there is no way I can connect to a remote DB2 server without a DB2 Client. The thing is, if I have the DB2 Client then I don't really need all those ODBC stuffs, so what's the point of their existence? And the client is not free, also can't be installed on my os. I have a debian running the trial client and it's working fine. But I still want to get my bsd box to work. By the way, I have no control over the server since it belongs to other people.

 

[ThJ]

ODBC is used to enable a large scope of applications to connect database without re-inventing the wheel for each database (e.g. Windows Office, OpenOffice, ... are able to connect *ALL* database through ODBC). It is not to avoid client licensing.

I already ask the question on another thread, what is your connection for?
If you are easy with Java you can use the db2 JDBC connector. You just need to find/ask for db2java.zip corresponding to your DB2 version and the JDBC connector is surely running on the server side.

Thierry

 

[Faroon]

Thanks for you help. db2java.zip can't work on openbsd and also it only come with the client (reside in sqllib/something). Bottom line is, I still need a client to pull data from the db2 server no matter whatever else software I have. By the way, anyone experienced with the pNET module?

 

[Faroon]

Thanks for mentioning JDBC. I tried using the db2jcc.jar file (by itself) and was able to connect to the server. Will have to buy the software though because IBM license extends to all individual files of a software, and db2jcc.far is part of the 8.1 client. But thanks for your help.