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

ASP.Net 3.5 connection to AS400

I need to connect to an AS400 database base and run a query from my web application....

Can anyone offer a suggestion on the best way to connect to a 400 using VB.NET?

I assume this can be done using ODBC but I dont know how.....plus I would prefer a quicker method if one exists.

Thanks!
0
ITHelper80
Asked:
ITHelper80
2 Solutions
 
Chad SmithSoftware EngineerCommented:
If you can install software on the server, Client Access comes with the iSeries .NET Data Provider that makes accessing data and programs easy.
0
 
ITHelper80Author Commented:
Thanks, I can install software on the server. Can you give me an example connection string using the .NET provider?
0
 
Bob LearnedCommented:
Data programmers best friend--www.connectionstrings.com

Connection strings for AS/400 (IBM iSeries)
http://www.connectionstrings.com/as-400

I should always be a fan of the HiT drivers:

http://www.hitsw.com/products_services/sql400/dlsql400.html
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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