Okay, let me toss my specs out first and get that out of the way. I'm running RedHat 8, trying to connect to an AS/400, using the DB2 "conpe" version 8.1, and I have unixODBC as my ODBC system. I think that covers it.

Here's my situation: We've got an AS/400 here at work, and I need to get a Linux machine to talk to it via ODBC so they can exchange i formation. Mostly, the Linux machine needs to pull data, for user validation, catalogue lists, etc. Unfortunately, I cannot get my Linux machine to talk to the AS/400. Now, I know the AS/400's ODBC port is open, because I can use MS Access to import table from it. The Windows DSN, via Rumba (from what used to be Wall Data), works. My Linux DSN does not.

I have wracked my brains, Googled, and looked through the DB2 information over on unixodbc.org; however, nothing works. At the risk of sounding like a DB2 newbie, which I am, can someone tell me what I'm doing wrong? What to I need to tweak in my odbcinst.ini and odbc.ini files to get isql, and subsequent scripts/apps, to connect across the network? Can I connect from a Linux client to an AS/400 by giving unixODBC an IP address? Any help would be appreciated! Thanks in advance!

Also, the following are my odbcinst.ini and odbc.ini files, respectively:

--- odbcinst.ini ---

[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1

[iSeries Access ODBC Driver]
Description = iSeries Access for Linux ODBC Driver
Driver = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
Setup = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
Threading = 2
FileUsage = 1

[DB2]
Description = DB2 Driver
Driver = /opt/IBM/db2/V8.1/lib/libdb2.so
FileUsage = 1
DontDLClose = 1

--- odbc.ini ---

[AS400]
Description = Connects to the as400
Driver = DB2

I'm not an expert in unixODBC but I suspect you might be attempting to use a wrong driver. I'd think you would use "iSeries Access ODBC Driver" and not "DB2 Driver" in your odbc.ini


Also, when you were googling, have you googled this:

http://www-1.ibm.com/servers/eserver...s/linux/guide/