>>I need information on how to access the AS/400 database from VFP 5.0:
>>1. The database driver name that is need for this task and how can I get it or purchase it ?
>>2. The sample statements for accessing the AS/400 database.
>> ( the step-by-step example )
>>
>>Your help is highly appreciated,
>>Andi Hidajat
>>pkshq@cbn.net.id
>
>Andi,
> I would think you could use an ODBC driver to link them... Now what Database on an AS/400??
>
>Thanx,
>
>Tony MIller
>Vancouver, Wa

Andi,

I use Client Access ODBC Driver (32-bit) version 0.00.0000 from IBM, file name CWBODBC.DLL.
The AS400 will require software as well. It works the same as connecting to any remote datasource. This approach is fine as long as the data size being transfered to the pc is small. You'll find the AS400 query engine runs well but the data transfer slooowww.

If your AS400 is presently being accessed via PC's with some type of terminal emulator then the emulator software most likely has an ODBC driver. I'm familiar with IBM's Client Access and Netsoft's AS400 router. Both have ODBC drivers. Check your ODBC administrator, you may have one loaded already.

HTH,
Mike