Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-04-20
7
Medium Priority
?
647 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 375 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This week I attended a Startup Week Chattanooga talk on Gender Diversity in Technology. Check out what I learned.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

597 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