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
Solved

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

Posted on 2004-04-20
7
637 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Some of the SEO trends we might expect in 2017.
This article explains the steps required to use the default Photos screensaver to display branding/corporate images
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

839 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