Solved

.NET provider to connect to AS400..........

Posted on 2004-04-20
7
643 Views
Last Modified: 2011-08-18

Does anyone know any .NET provider to connect to AS400.  I want to write an asp.net app to connect to AS400.  Any comments/suggestions?

cm
0
Comment
Question by:chandukb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 

Accepted Solution

by:
caslan earned 125 total points
ID: 10872867
Here is an example of how I am performing a connection to the 400

In my example I store the connection settings within the Web.config file.

<configuration>

    <appSettings>
          <add key="Conn400" value="Provider=IBMDA400;Password=password;User ID=loginname;DATA SOURCE=Your400"></add>
    </appSettings>

Within dataaccess function:
'This will get the connection string from the web.config(safe storage of your connect string)
        Dim conn400 As New OleDb.OleDbConnection(ConfigurationSettings.AppSettings("Conn400"))
       
        conn400.Open()
        Try
           'your code here
        Catch ex As Exception
           'error handling
        Finally
            conn400.Close()
End Try

Hope this helps and good luck.
0
 
LVL 2

Author Comment

by:chandukb
ID: 10877667
caslan,

I am interested in .NET provider only.  I already have an applicaton with oledb connection, but I am trying to convert it to asp.net app with .net provider.  Do you know, where can I find .net provider.  Thanx

cm
0
 

Expert Comment

by:caslan
ID: 10879381
cm,

Do you have IBM Client Access?
We are currently using IBM Client Access 5.2...

caslan
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 2

Author Comment

by:chandukb
ID: 10879878
Yes,

we have Client Access, but it doesn't have .NET provicer, it has only olddb(IBMDA400) provider, but I am looking for .Net pr0vider, so that I can use all .Net features like data sets etc.,

Thanx
cm
0
 

Expert Comment

by:caslan
ID: 10881232
cm.

I may be misunderstanding. You should be able to make a connection to the datasource using the IBMDA400.Datasource.1 provider that comes with Client Access.  Using Dataset, etc should still be possible.

Create the connection within VS.NET, and you should be able to drag and drop datasets into your work environment.  It is a little flakey, but it gets the job done.

Let me know if this helps or if you need more assistance.  I have been working with this provider the past year, I am not an expert but I have used it extensively within my current project.  

HTH
caslan
0
 
LVL 2

Author Comment

by:chandukb
ID: 10899404
caslan,

IBMDA400 allows only oledb provider connections and allows recordset processing.  I am looking for .Net provider due to performance benefit of using Datasets with bulk inserts/updates.

I was searching on the net and found the following:

http://www-1.ibm.com/servers/eserver/iseries/access/windows/beta.html#overview

probably, this is the .Net provider I am looking for and it is in Beta.  I will try to find more infor on this.  Any comments?

Thank You
cm
0
 
LVL 1

Expert Comment

by:MarcoMi66
ID: 10936776
If I am not wrong a .NET provider will be included in iSeries Access starting from V5R3 (i think expected in June)
If you cannot wait, here is the address of a well-known producer of Data Access Driver for iSeries.
http://www.hitsw.com/products_services/sql400/sql400.html
Marco
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
We take a look at some of the most common obstacles that IT teams run into as they work relentlessly to keep all the alarms and sirens from going off at once.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question