>I have a client that imports AS400 data into Paradox tables for local PC applications. I have written some small reporting apps in vfp5 to query their store of Paradox tables. I would like to extend the scope of these apps and do away with their file importing by pulling data directly from the 400. My knowledge of AS400 connectivity is limited and I'm looking for some clear info/steps on getting AS400 access via FoxPro. Any info on AS400 ODBC drivers that Fox supports would be helpful, as well as any tools that are available (i.e. Rhumba's AS400 SDk)
>
>So far I am finding lots of support/tools/training for AS400 access via VB, but little to nothing for FoxPro. I may not have the time to make the jump to VB in time to deliver according to the client's delivery request, so I'd like to stick with VFP for now if possible.
>
>Thanks in advance...

StarSQL (from IBM?) is a very effective tool for accessing the AS400. I've used it with fox 2.6 onto a 16bit and a 32bit server - you need different drivers. I used Fox's connectivity pack which I haven't explored in VFP - like is there one or is it built into the pro license or ....

I found that getting the permissions straight in the AS400 was my biggest headache and the error messages in fox weren't always the most helpful. For debugging the connection I used Access (I only know how to link tables but it does me) and worked from there. Once I got it going it was very reliable.

HTH - Sarah