473,857 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
3 4081
Anyone knows?

Laurence

Dec 23 '05 #2
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.as 400.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
Thanks Karl, for your reply & info.

Laurence

Dec 25 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1414
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 from a Windows 2000 computer. When I go to Start -> Settings -> Control Panel -> Administrative Tools -> ODBC Data Sources
1
14953
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 new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error:
2
16531
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 will be just retrieving and displaying data. No inserts/updates/etc.
1
3376
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 CONNECT TO SQL SERVER DESKTOP ENGINE DATABASES AND MICROSOFT ACCESS DATABASES WTIH THIS VERSION OF VISUAL STUDIO." -What Version Of Visual Studio do I need?
5
5762
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 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
1
6064
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 a different computer, we have to send them the batch program to put the ODBC hooks on that machine. We want to get around that by using Pass-Through queries and the ODBC connection string. What we have got to work is this: ...
6
4608
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 installed it, but apparently I need an additional product, "DB Connect" to actually make a connection. "DB connect" says that it will only display tables with a type of "T", and as far as I know, we are using files, not tables on the 400. Can...
1
9333
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 to connect to the remote host using a simple connect statement, DB2 hangs. The connection statement I'm using (I've obviously obscured the parameter names): $ ./db2 connect to DATABASENAME user USERNAME using PASSWORD;
2
3080
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 connecting? Which is best? Thanks, Franc.
0
11083
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10711
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10808
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10394
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7104
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5971
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4592
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4191
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3215
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.