AS400 - .NET Framework

hi all
what do i need to connect an VB.NET application that uses ADO.NET to an IBM
AS400

thks
JSB

Nov 22 '05 #1

1478

João,
Its best to be on Client Access V5R2 or later (with current all PTFs) to be
fully supported from .NET. (I understand that you can remain on an older
OS/400 such as V4R5, its the client that needs to be current).

http://www-1.ibm.com/servers/eserver...edb/index.html

http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341

The above links are from June 3rd, not sure if there are more current
versions with better support...

If you look around the SQL Thing site (http://www.sqlthing.com) and the
above sites you should come across a number of samples and further
information.

I understand that Client Access V5R3 will include a "native" .NET Data
Provider, which should see an improvement in performance!

http://www.iseriesnetwork.com/news/n...6&channel=news
Hope this helps
Jay
"Santa Bárbara" <jo****@i24portugal.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

hi all
what do i need to connect an VB.NET application that uses ADO.NET to an IBM AS400

thks
JSB

Nov 22 '05 #2

João Santa Bárbara

thks i will take a look

thks
JSB

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:ON**************@TK2MSFTNGP11.phx.gbl...

João,
Its best to be on Client Access V5R2 or later (with current all PTFs) to be fully supported from .NET. (I understand that you can remain on an older
OS/400 such as V4R5, its the client that needs to be current).

http://www-1.ibm.com/servers/eserver...edb/index.html

http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341
The above links are from June 3rd, not sure if there are more current
versions with better support...

If you look around the SQL Thing site (http://www.sqlthing.com) and the
above sites you should come across a number of samples and further
information.

I understand that Client Access V5R3 will include a "native" .NET Data
Provider, which should see an improvement in performance!

http://www.iseriesnetwork.com/news/n...6&channel=news
Hope this helps
Jay
"Santa Bárbara" <jo****@i24portugal.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
hi all
what do i need to connect an VB.NET application that uses ADO.NET to an

IBM
AS400

thks
JSB

Nov 22 '05 #3

Similar topics

Defining AS400 Linked Server

by: fn | last post by:

Can anyone help me understand what it takes to define a Linked Server connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server or some other product or can I simply do it with the...

Microsoft SQL Server

IBM AS400 DB2 Data connection driver for VB.NET (ADO.NET)

by: Niyazi | last post by:

Hi, Our company uses IBM AS400 and DB2 (version 4.5 I guess). I have to do some report but I donot know how to access the AS400 DB2. I search IBM unfortunately IBM site in mess. Can anyone tell...

.NET Framework

Excel, DB2, AS400 (retriving data and sending into Excell)

by: Niyazi | last post by:

Hi, I have to retrieve a data from AS400 DB2 and after working with data I have to export into one of existing Excel file. I can connect into specific library in AS400 DB2 using AS400...

.NET Framework

by: CompDude | last post by:

Hi All I am trying to copy data from DB2 to SQL server using SQL Data Tranformation Services. I am able to do that by supplying AS400 username/password along with the iSeries DSN Name, at the...

DB2 Database

as400 driver

by: alan_sec | last post by:

Hi. Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that is installed on windows 2000? I' m trying to...

DB2 Database

AS400 from VB.NET

by: Sehboo | last post by:

Hello, we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access that from my vb.net application. I don't know anything about AS400. Is it possible to get data from tables and stored...

Visual Basic .NET

strange error when trying to call a CL from vb.net

by: Amaryllis | last post by:

I'm trying to call a CL which is located on our AS400 from a Windows application. I've tried to code it in different ways, but I seem to get the same error every time. Does anyone have any clue...

Visual Basic .NET

AS400 - Ado.Net from Vb.Net Slow Query Times

by: MadMan2004 | last post by:

Hello all! I'm having a problem with a project I'm working on and I'd like to ask for anyone's input that might be helpful. I'm building a rather large front-end application connecting to an...

Visual Basic .NET

AS400 to AS400 connection

by: Iain | last post by:

Hi All I am creating a database trigger to write details real time from tables on one AS400 to another over our WAN. Is there such a concept as ODBC connections on the AS400 to perform this...

DB2 Database

AS400 and SQL DTS

by: accyboy1981 | last post by:

Hi, I'm new to AS400 and am trying to copy the contents of a table from an SQL Server 2000 table to a table in AS400, I'm doing this using DTS. I'm connecting using the iSeries Access ODBC...

DB2 Database

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General