ASP.NET 2.0 Need connection to as/400

I have been tasked with connecting to an AS400 from an ASP.NET application. The AS/400 people are no help, they are like SQL what is that, ODBC? ADO? never heard of them.

So I Know nothing about the as400 but still need to connect to it.  I tried adding this connection string to my web.config but got an error.

  <add name="JDEConnection" connectionString="Provider=IBMDA400;Data Source=mysystem;User ID=myusername;Password=mypassword;" />

This gives me the folloring error:

System.ArgumentException: Keyword not supported: 'provider'.

Where do i go from here?
LVL 4
dukestaTAIAsked:
Who is Participating?
 
mmarksburyConnect With a Mentor Commented:
A Webcast on .NET and AS/400:
http://whitepapers.zdnet.co.uk/0,39025945,60119113p-39000589q,00.htm

Beta Data Provider for AS/400 by IBM:
http://blogs.msdn.com/vsdata/archive/2004/04/13/112862.aspx

This site has a DSN Less ODBC Connection String for AS/400:
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAS400

I found these doing a search for ".net as/400 dsn less"

Good luck!
0
 
mmarksburyCommented:
Go here and scroll down.  You'll see OLE and ODBC connection strings for AS400.  Good luck.

http://www.connectionstrings.com/
0
 
dukestaTAIAuthor Commented:
mmarksbury
 I have already been to this site.  Do I have to have the ODBC driver installed for Client Access?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
mmarksburyCommented:
The ODBC driver is not required for client access because the server is handling the communication.
0
 
mmarksburyCommented:
Are you still having problems, and if so, what is the error message?  Please post your connection code so we can see what is going on.  This will allow us to offer better advice.

0
 
dukestaTAIAuthor Commented:
Well here is what I have.

I installed the Client access ODBC driver and created a System DSN.

This works fine but I was wondering if there is a more efficient way than using ODBC, like a native provider or web services?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.