Re: OS/400 as client to NT file server

Buck

At 09:02 AM 4/22/1998 -0400, you wrote:
>We're using a PC based help desk product and would like to be able to 
>upload the trouble reports to our AS/400 based billing system.  In 
>addition, we need to update the PC database so it knows which troubles 
>have been uploaded to the AS/400.
>
>Where do I start looking?
>
>Can the 400 act as an ODBC client?  How?

I'm gettin' wild here, I think, but here goes:

1. ODBC client? No. BUT---

   DRDA lets you specify something called an ARD (application request
driver) that is provided by a DBMS vendor and is installed on the 400. I
think there's something for SQL Server, not sure. Was an article in
News/400 a while back. Search their archives/CD for more. BTW, IBM Support
Line has not been at all helpful in directing me to resources in this area.
The 'not our responsibility' syndrome.

   There's an SQL CLI (call level interface) that has function calls that
are identical to those of ODBC. These are documented for C but should be
usable in RPGLE, too, I think.

2. Uploading is no problem—FTP comes to mind, and there's a great FREE FTP
server available for NT (WAR-FTPD; dig around at <http://www.tucows.com> ot
<http://www.stroud.com> ). Then the 400 can control the transaction, if
desired.

3. Brute force: can the PC file be uploaded and then modified on the 400
and downloaded again?

4. Can you put NFS service on the NT box? Then you can mount the NT file
system as local to the 400's IFS. Kinda scary, though.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---