>>>Does anybody know of a good ODBC driver for accessing AS/400 data?
>>>The legacy data that I'm trying to access is in the old style System/36 format, not DB2.
>>
>>Jim,
>>We got our stuff from IBM (just call them). You must call them because not only will you need the ODBC driver for the pc, but you will need
>>some special AS400 software.
>>
>>And don't fret ... IBM actually gives the stuff away free.
>
>Who did you talk to at IBM, the folks we talked to led us to believe that if we weren't using DB2 files, we couldn't access them with their tools. I think they wanted us to Client Access.
>
>What is the piece of software that runs on the AS/400? None of the other venders we contacted seemed to think we needed any. I couldn't find anybody which seemed to have the full picture of all the pieces we needed to make things work.

I don't know what the software is ... IBM sent it. But Client Access
does have ODBC so if you have that you can play with it.

Calling IBM is almost useless for technical support. We got their attitude for support of VFP/VB as what are those products. "Microsoft" ... who is that?

Literally, if you currently use Client Access, since it is using ODBC you should be able to make a connection with it.

Have you ever used Rumba to access the AS400?