Solved

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

Posted on 2000-04-05
8
252 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
Technology Partners: 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!

 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBS file using code from 2nd file (txt or vbs) 4 48
Passing a Text Box name to a Sub 6 102
vbModal 12 66
Problem to line 23 74
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

696 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