Re: SQL server and the AS/400

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

Wayne--

Forget ODBC for the VB-to-AS/400 connection and use OLE DB! Like ODBC, it
comes with CA/400 (the part that doesn't need licensed) and makes a good
realtime pipeline between your VB app and the AS/400. See
www.as400.ibm.com/clientaccess/oledb for more details.

OLE DB also makes a great real-time connection between Excel, Access and
others to the AS/400. OLE DB is a woefully overlooked resource! It's not the
most bulletproof, scalable option, but when it fits well, it makes a great
solution.

rp


----- Original Message -----
From: Wayne Capwell <wayne@redoaktech.com>
To: midrange <MIDRANGE-L@midrange.com>
Sent: Friday, 19 November, 1999 11:14 AM
Subject: SQL server and the AS/400


> An existing VB application accessing data on SQL server is to be
> modified to get some of the data from the AS/400 directly. (Currently
> the AS/400 data is downloaded to SQL overnight.  This is what we want
> to  eliminate.)
>
> Can I just create a Client Access ODBC link from the server to the
> AS/400 and get to the data directly?  What changes must be made in the
> VB app?  Are there any special considerations regarding as/400 user ids
> and passwords that need to be enabled in the VB app?
>
> About half of the users are on Rumba and want to stay that way.  Are
> there any considerations for this group?  Can Rumba make use of the ODBC
> connection created thru Client Access?
>
> Please point me to any magazines or websites that address this area. I
> have visited Rumba and the Redbooks sites and come away less informed.
> Thanks
> Wayne
> --
> ______________________________________
> Wayne W. Capwell
> Red Oak Technologies, Inc.
> 11301 Carmel Commons Blvd., Suite 114
> Charlotte, NC  28226
> 704-945-1067
>
> Manufacturing...Production...Solutions
>      http://www.redoaktech.com/
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---