Connecting to AS400 running on IBM with MS Access

[Nathan Given]

Hello All,

I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.

I FINALLY figured out how to connect with Coldfusion (see instructions
below).

So, now I am trying to connect to the same database with MS Access. I
want to link the tables within Access so I can quickly query and answer
questions.

The problem is that I HAVE NO IDEA how to do this. I'm familiar with
linking tables to other databases (MySQL, MS SQL Server, Oracle), but
I've never done it for IBM DB2 (I'm not even familiar with the IBM
terminology). Usually I just download the ODBC driver, install it,
then I create a new datasource in Windows XP. After the new datasource
is created, I'm able to connect no problem.

Can anyone walk me through the process of creating an ODBC connection
to a DB2 database? What do I need to download (and where do I find the
download files)? How do I set up the connection? What port do I use?

Thanks!
--
nathan

PS: I may use the wrong terminology... I'm not an IBM guru and I don't
know the difference between AS/400, iSeries, and DB2.

PPS here is how I connect with coldfusion:
1) Download the jtopen driver from IBM [1]
2) Unzip it and point the Coldfusion class path [2] to where the jar
files are [3]
3) Create a new connection in
JDBC URL: jdbc:as400://10.11.26.2/alumfhss
Driver class: com.ibm.as400.a ccess.AS400JDBC Driver
[1] http://tinyurl.com/bfnm4 (
http://www14.software.ibm.com/webapp...BW71&S_CMP=&s=
)
[2] Coldfusion administrator > Java and JVM
[3] I put the jars in C:\CFusionMX\jd bc\jtopen_5_0\l ib, so my class
path looks like C:\CFusionMX\jd bc\jtopen_5_0\l ib,

[Brian Tkatch]

IIUC, The connection to DB2 is via the UDB client, installed on the
local machine. Set the connection up there, and there is even an option
for it to make the ODBC entry for you.

B.

[Larry]

Nathan Given wrote:

Hello All,

I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.

I FINALLY figured out how to connect with Coldfusion (see instructions
below).

So, now I am trying to connect to the same database with MS Access. I
want to link the tables within Access so I can quickly query and answer
questions.

The problem is that I HAVE NO IDEA how to do this. I'm familiar with
linking tables to other databases (MySQL, MS SQL Server, Oracle), but
I've never done it for IBM DB2 (I'm not even familiar with the IBM
terminology). Usually I just download the ODBC driver, install it,
then I create a new datasource in Windows XP. After the new datasource
is created, I'm able to connect no problem.

Can anyone walk me through the process of creating an ODBC connection
to a DB2 database? What do I need to download (and where do I find the
download files)? How do I set up the connection? What port do I use?

Thanks!
--
nathan

PS: I may use the wrong terminology... I'm not an IBM guru and I don't
know the difference between AS/400, iSeries, and DB2.

PPS here is how I connect with coldfusion:
1) Download the jtopen driver from IBM [1]
2) Unzip it and point the Coldfusion class path [2] to where the jar
files are [3]
3) Create a new connection in
JDBC URL: jdbc:as400://10.11.26.2/alumfhss
Driver class: com.ibm.as400.a ccess.AS400JDBC Driver
[1] http://tinyurl.com/bfnm4 (
http://www14.software.ibm.com/webapp...BW71&S_CMP=&s=
)
[2] Coldfusion administrator > Java and JVM
[3] I put the jars in C:\CFusionMX\jd bc\jtopen_5_0\l ib, so my class
path looks like C:\CFusionMX\jd bc\jtopen_5_0\l ib,

Connection to DB2 on i-series requires DB2 Connect. DB2 Connect is part
of DB2 UDB ESE (limited license), but not part of DB2 UDB Personal
Edition or Workgroup Edition. You can find information about how to go
about doing this here:

http://www-306.ibm.com/software/data...manualsv8.html

see Installation and Configuration Supplement, Connectivity Supplement,
Quick Beginnings for DB2 Connect Enterprise Edition, DB2 Connect User's
Guide. In the Connectivity Supplement (chapter 8), you will find
references to other i-series publications that you will need to read.

Larry Edelstein

[Karl Hanson]

Larry wrote:

Nathan Given wrote:

Hello All,

I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.

I FINALLY figured out how to connect with Coldfusion (see instructions
below).

So, now I am trying to connect to the same database with MS Access. I
want to link the tables within Access so I can quickly query and answer
questions.
<snip>

Connection to DB2 on i-series requires DB2 Connect. DB2 Connect is part
of DB2 UDB ESE (limited license), but not part of DB2 UDB Personal
Edition or Workgroup Edition. You can find information about how to go
about doing this here:

http://www-306.ibm.com/software/data...manualsv8.html

see Installation and Configuration Supplement, Connectivity Supplement,
Quick Beginnings for DB2 Connect Enterprise Edition, DB2 Connect User's
Guide. In the Connectivity Supplement (chapter 8), you will find
references to other i-series publications that you will need to read.

Larry Edelstein

DB2 Connect is one way to connect to DB2 UDB for iSeries. However many
people use ODBC (and other) support provided by iSeries Access.

http://www-03.ibm.com/servers/eserve...languages.html
http://publib.boulder.ibm.com/infoce...aikcaapidb.htm
--
Karl Hanson

[Nathan Given]

I've started reading the manuals. In the meantime, I have some
questions:

Is ESE an abbreviation?
Where can I download DB2 UDB ESE?

Thanks!
--
Nathan

[Mark A]

"Nathan Given" <na**********@g mail.com> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com...

I've started reading the manuals. In the meantime, I have some
questions:

Is ESE an abbreviation?
Where can I download DB2 UDB ESE?

Thanks!
--
Nathan

Enterprise Server Edition

You can get a 90 try and buy license version of ESE, or Personal Developers
Edition:

Go to http://www-306.ibm.com/software/
select Trials and betas (left side)
search on db2
registration is free