Solved

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

Posted on 2000-04-05
8
250 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

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…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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…
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…

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