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

Connecting to AS400 running on IBM with MS Access

P: n/a
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.access.AS400JDBCDriver
[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\jdbc\jtopen_5_0\lib, so my class
path looks like C:\CFusionMX\jdbc\jtopen_5_0\lib,

Jan 24 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.

Jan 24 '06 #2

P: n/a
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.access.AS400JDBCDriver
[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\jdbc\jtopen_5_0\lib, so my class
path looks like C:\CFusionMX\jdbc\jtopen_5_0\lib,

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
Jan 24 '06 #3

P: n/a
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
Jan 24 '06 #4

P: n/a
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

Jan 25 '06 #5

P: n/a
"Nathan Given" <na**********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.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
Jan 25 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.