Solved

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

Posted on 2000-04-05
8
249 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA: Add rows to listbox based on criteria 7 74
VBA to copy paste columns form one file to other 20 85
using Access 8 59
passing parameter in sql procedure 9 56
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now