Connect to AS400 using .NET

views:

211

answers:

+6 Q:

Connect to AS400 using .NET

Hi Guys,

I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400.

What do I have to install on my machine (or the AS400 server) in order to connect? (IBM iSeries Access for Windows ??)

What are the components of the connection string?

Where can I find sample codes on building the Data Access Layer using SQL commands?

Thanks.

+3 A:

You need the AS400 .Net data provider. Check here: http://www-03.ibm.com/systems/i/software/access/windows/dotnet/index.html

For connection string samples, check here: http://www.connectionstrings.com/as-400

Also, check out the redbook for code examples and getting started. http://www.redbooks.ibm.com/redbooks/pdfs/sg246440.pdf

dcp 2010-07-26 16:08:33

There is no download link for that .NET data provider. Does that come with the AS400 itself?

madatanic 2010-07-26 16:14:30

Refer to this link: http://forums.asp.net/p/1497318/3610952.aspx According to that, it should be in the following folder as long as you have the IBM iSeries Access for Windows Client installed : C:\Program Files\IBM\Client Access\IBM.Data.DB2.iSeries.dll

dcp 2010-07-26 16:23:28

Sorry, maybe I was unclear of my question. Where can I get the IBM iSeries Access for Windows Client?

madatanic 2010-07-26 18:33:15

@madantanic - No problem. I think you have to get this software from IBM. It's been a long time since I worked on the AS/400 (I was using JAVA to access it back then), but if I remember correctly, in our shop we had to contact our support rep from IBM and they sent us the CD for it. I'd start with your AS/400 system administrator and tell them what you need. I don't think the stuff is freely downloadable, unfortunately.

dcp 2010-07-26 18:38:49

Thanks for your help.

madatanic 2010-07-26 18:58:45

You need the media from IBM, or have an IBM account allowing you to download the software.

Thorbjørn Ravn Andersen 2010-08-12 09:39:23

ansaurus

tags:

views:

answers:

Connect to AS400 using .NET

related questions