• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 546
  • Last Modified:

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?
0
dukestaTAI
Asked:
dukestaTAI
  • 4
  • 2
1 Solution
 
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
 
mmarksburyCommented:
The ODBC driver is not required for client access because the server is handling the communication.
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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
 
mmarksburyCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now