Solved

Using VB to acces the AS\400 through TCP/IP

Posted on 2000-04-05
8
251 Views
Last Modified: 2012-08-13
Currently i am accessing the AS\400 via ICF using Netsoft router.  This is done using E32APPC routine.  When using this to try and connect to the AS\400 through a TCP/IP router it doesn't work.
Can anyone help??  And give me a routine that will allow connection through TCP/IP, or maybe some advice.  ICF is the only way we communicate with RPG as we find it the safest way.  So no comments on using ODBC or any other format please.

Thanks

Chris
0
Comment
Question by:CRICE
  • 4
  • 3
8 Comments
 

Author Comment

by:CRICE
ID: 2689140
Adjusted points from 100 to 150
0
 

Expert Comment

by:TGB
ID: 2690304
Try putting this question in the AS/400 section. I don't think the VBguys here know enough about the As/400 to answer this question.
0
 
LVL 28

Expert Comment

by:AzraSound
ID: 2692286
i consulted some of my os400 guru buddies and i'll try to report back the best i can what they told me.  they dont do a lot of porting between vb and rpg so i dont know how up to date their knowledge is of the matter.  they seemed to only know of using appc as you use currently with icf.  however they dont seem to believe that this will work with tcp/ip even though they predict with the popularity of tcp/ip nowadays it should only be a matter of time before ibm develops something that will apply to this situation.  using a direct tcp/ip wont work because the translations that the icf does to allow vb and rpg to communicate isnt present with just a plain tcp/ip connection. they seemed to believe the only alternative would be some third party software that would make it compatible.  asna visual rpg is supposed to be quite good except for the big draw back that they didnt include external data structures compatibility in their software.  if you have more specific questions about any of this let me know and i will inquire about it for you.  i probably misquoted my sources plenty as it is already.   =)
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:CRICE
ID: 2692586
Thanks very much for your time in finding this information out for me.  Is it the netsoft software that is incompatible with TC/IP to ICF communication or is it the ICF communication that is incompatible with TC/IP (if any of that makes sensce).
0
 
LVL 28

Expert Comment

by:AzraSound
ID: 2693565
i will ask them in particular about the netsoft software but from what i understood, only the appc protocol supports icf transfers at this time.  but as tcp/ip is becoming the norm and everyone is developing using tcp/ip, we should expect to see icf available for tcp/ip in the near future.  as far as they knew, there is no way to acheive this solely through tcp/ip, but only through another third party software that provides direct communication or some other means to communicate with rpg on the 400.
0
 
LVL 28

Accepted Solution

by:
AzraSound earned 150 total points
ID: 2717935
http://www.as400.ibm.com/tcpip/

i found this. don't know if its of any interest but its an ibm product allowing as400 users to link to tcp/ip networks

if theres anything else you want me to find out for you let me know
0
 

Author Comment

by:CRICE
ID: 2721915
Cheers for all your help, it's been much appreciated.

I did actually discover a way of dealing with the TCP/IP problem.  I have set up a NetSoft Anynet router which allows the VB APPC routine to work with the TCP/IP connection.

I'm giving you the point's, because you have spent a lot of time looking at this problem for me.

Thanks

Chris.
0
 
LVL 28

Expert Comment

by:AzraSound
ID: 2721926
thanks for the points. i'm just glad you got the thing working.  

cheers
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Acccess - Update Field in Table when report is printed 6 46
How to measure sizes and angles in scanned images ? 3 75
MsgBox 4 68
Formula problem with Excel attachment 6 38
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

809 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