Connecting DB2/400 through iSeries Access drivers or DB2 Connect, which's more efficent?

Laurence

Hi there,

Does somebody know the efficent way to connect DB2/400? Through iSeries
Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and
efficent?

In addition, does DB2 Connect use APPC over TCP/IP protocol? Or SNA
protocol?
Thanks in advance~

Dec 21 '05 #1

Subscribe Post Reply

4034

Laurence

Anyone knows?

Laurence

Dec 23 '05 #2

Karl Hanson

Laurence wrote:

Anyone knows?

Laurence

Most connections nowdays between either DB2 Connect client or iSeries
Access client and DB2 UDB for iSeries server are TCP/IP. You can use
APPC for DB2 Connect if you like. DB2 Connect flows DRDA datastream
while iSeries Access flows a protocol unique to iSeries.

I can't offer any comparative info about efficiency of one vs the other.
You might ask over on the comp.sys.ibm.as400.misc newsgroup, as a
number of iSeries customers follow that.

More info here about configuring for DB2 Connect (using DRDA) is in the
Distributed Database Programming book:
http://publib.boulder.ibm.com/infoce...dp/rbal102.htm

More info about using iSeries Access is in the InfoCenter:
http://publib.boulder.ibm.com/infoce...v5r3/index.jsp
Connecting to iSeries
iSeries Access
iSeries Access for Windows
Programming
Database Programming

--
Karl Hanson

Dec 23 '05 #3

Laurence

Thanks Karl, for your reply & info.

Laurence

Dec 25 '05 #4

Similar topics

Connecting to SQL Server from ASP

by: nzanella | last post by:

Hello, I have MS SQL Server running on a server computer. I am trying to connect to it via ASP from a .asp file created in a virtual directory. I am using IIS as the web server. I am connecting...

Microsoft SQL Server

IBM.Data.DB2.iSeries database access problem

by: Yanik Reid | last post by:

When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the...

DB2 Database

Connecting to Informix

by: Mark | last post by:

We need to connect to an in-house informix database from a .NET web application. Any recommendations on: 1. Drivers. 2. Connection strings. 3. Ways to optimize speed? This particular app...

C# / C Sharp

Connecting to an IBM AS/400 with Visual Basic.NET

by: ben_chicago | last post by:

I JUST INSTALLED Visual Basic.NET BUT, CANNOT CONNECT TO MY AS/400 (OS400 5.1). WHEN I TRY TO CONNECT I GET A SERVER EXPLORER MSG: "UNABLE TO CONNNECT TO DATABASE. IT IS ONLY POSSIBLE TO...

Visual Basic .NET

Connecting to AS400 running on IBM with MS Access

by: Nathan Given | last post by:

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...

DB2 Database

Connecting to iSeries with MS Access

by: Chevylover54 | last post by:

We have been using ODBC connections that are in the registry of the computer. However these connections aren't in by default so when a new user uses the Access program or when a current user goes to...

Microsoft Access / VBA

Connect ASP.net(2.0) to AS400 Iseries w/ DB2

by: Al G | last post by:

Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and...

DB2 Database

Linux DB2 Client Hangs when Connecting to Remote Host

by: malooga | last post by:

Hello, I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try...

DB2 Database

Connecting to SAGE

by: franc sutherland | last post by:

Hi, I am trying to build a database in Access 2003 which can connect to information in a SAGE system. Should I use ODBC, and if so, which driver is required? Is there another way of...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA