Solved

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

Posted on 2004-04-20
7
631 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now