Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run VFP program remotely due to AS400 ODBC timeou
Message
From
11/03/2002 15:10:25
 
 
To
11/03/2002 14:24:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00630301
Message ID:
00631156
Views:
31
>Setting the timeouts doesn't work. NV is too far away even when the timeout is set to 10 minutes, because we are using the AS400 at it's slowest access level, batch status. We have tried all of the above. Which brings this question back to where it started...
>
>How can an application be set up on a server here so that it executes here but a remote user can execute it and get a result set? Is the only way to do this through HTML?

Hello Margaret,

I have the chance of working with an AS400 system(white box) in the past and
things I discoverd was that the biggest problem with ODBC is it runs at priority 20 because of the class QPWFSERVER assigned to the prestart jobs QZDAINIT and QZDASOINIT in subsystem QSERVER. Your system admin on the AS400 cna modified the prestart job to use class QBATCH instead in order to enforce priority 50 on ODBC, but I wast not in NV , it was for internal pourposes.

My other though on your problem will be stablishing socket conections from
NV to your local server, keep the connection alive by sending raw data till
your data set becomes available from the AS400 queries.

By means of "HTML" you will need a cgi module (COM, dll) to server in that
function too, create the data, and then transer it from your local server
to NV. that way the COM or dll object will reside on the local server not on
the remote, and it will take advantage of the full resources of your local
machine

just my 2 cents

mark oliva
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform