?
Solved

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

Posted on 2004-04-20
7
Medium Priority
?
644 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
New style of hardware planning for Microsoft Exchange server.
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

770 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