Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

AS400 and VB

AS400 and VB

AS400 and VB

I need information on how to set up a VB program to communicate with an AS400 system. Is there, for instance, an ODBC driver available that will let me access data from an AS400 or is it more complicated than that? Any information will help.

RE: AS400 and VB

There is a Forum on this site called "IBM servers Forum"
they may help you better

the ODBC (Open Database Connectivity) driver if you need one will be for the "Database" you work with Not the Operating System.

RE: AS400 and VB

tcorrigan - in most cases doug would be right - but in this case the operating system and the database are the same thing - so you just need an ODBC driver for the AS/400

We used one a while ago - but couldn't get the performance from ODBC - you might like to look at IBM's Client Access product


Mike Lacey
Cargill's Corporate Web Site

RE: AS400 and VB

Thanks for the information, guys. Doug, I looked for the IBM Servers Forum on this site, but couldn't find one by that name. Could you possibly let me know how you drill down from the home page to that forum.

I did find a product from NetManage that seems to do what I need, but if anybody out there has any experience with this package or anything else, I'd like to hear from you.

Tom Corrigan

RE: AS400 and VB

Not much posting in there now, but the IBM Servers forum is located in the Hardware, Server Rack, Servers area of the site. FYI.


RE: AS400 and VB

Hi Tom,

The project that I'm currently working on is an AS/400 client/server one. We use VB as the front-end and DB2/400 as the database. The middleware we're using to access the AS/400 is called ACE/400 from www.missystems.com

This product gives us record level access to any physical or logical file, record locking, remote commands, commitment control, etc. You can read files in a similar fashion to RPG processing such as SETLL, READE (different command names of course) or you can use SQL statements (e.g. SELECT CUSNO, CUSNAM FROM CUSLIB/CUSMST WHERE CUSSTS = "A"). We use both methods. Performance is basically a non-issue as it is very fast.

There are a couple of glitches with connections that are being worked on as we speak and I hope to get a fix from them soon (not a show stopper).

There are other products that do similar things, give or take a couple of features:

www.asna.com -- Database Toolbox
www.teca.com -- Data400
www.SystemObjects -- ActiveObjects/400 for VB

There are many other products out there, some that give you TCP/IP (like the above mentioned) and others only give you SNA connectivity.

I would highly recommend downloading trial versions (they all have them), design a small test application and check for speed, reliability and ease of use -- oh yeah, and cost (-:

Hope this helps!


RE: AS400 and VB

Thanks everybody for your responses. I think I have enough now to go out and make a decision.

Tom Corrigan

RE: AS400 and VB


If it'n not too much trouble, please share your decision here so that we can learn!


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close