Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: Shawn Ottinger
  Where is Shawn Ottinger?
 Greeneville TN
 Tennessee - United States
 Shawn Ottinger
Subject: RE: Using ODBC
Thread ID: 16129 Message ID: 16203 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, October 11, 2002 11:18:36 AM         

> I have to read information from an AS400.
> I understand how to use "create remote view" and I know there are some othere options. My question is what is the best and fastest way to get data from a platform like this.
> These will be large tables and I will be searching through them .
> I dont need detailed instructions, just looking for concepts right now.

Nobody has answered you and I think that there are probably not a lot of us
familar with the AS400. I do not know if it is ADO compliant. ODBC may not
be the fastest way, but when reading the documentation it maybe the only way.
Basically ODBC as you know requires a remote view and is a lot slower than
other means to access the date. You comment on the fastest way to get data,
if you are looking at a one time shot say in a data-port, ODBC will do. But
if you are looking at accessing, reading and writing on an ongoing bases look
on the MS web site under ADO and see if the AS400 supports it.

Pete from the Great White North ! (Only in Canada, ay...) Over and Out ...


Using ODBC Posted by Shawn Ottinger @ 10/9/2002 8:51:59 PM
RE: Using ODBC Posted by Pete Sass @ 10/11/2002 11:18:36 AM
Client Access from IBM. Posted by Khalil Shaddad @ 10/11/2002 12:50:38 PM
RE: Client Access from IBM. Posted by Neil Fairbanks @ 10/11/2002 4:30:25 PM