With Postgres I used the ODBC connection. The big issue for me was the error messages returned. So what you did with MySQL was the same as I did with the Postgres engine. Also, using MsSQL is the same when using SPT. Recently, MySQL came out with a new driver for the MySQL ver 5.0 which I'd hope would be much better than in the past.

>I think this thread is also talking about VFP on a Linux >Desktop

I was able to get VFP 8.0 to work using wine. But I never used it at a client site. The coolest thing was I was able to setup a VNC (and a NX) connection from linux (also windows) which I started five sessions. It actually ran faster. Mostly because the data access was local. Of course this was on the local lan. I thought it would be the best solution to the license issues. The only issue of course was the server requirements- wine uses a lot of resources. I ran a commerical accounting system without any problems. Mixing Linux clients with Windows (using samba) seem to work but I didn't really check everything. So it's real - but may not scale well. My guess is running virual OS software might be a better solution.

Well all this talk got me to do something. I made the move and I am the latest owner of the RealBasic software. So far it runs very nice. I want it to connect to a Postgres engine so I downloaded a third party plugin. What is cool (the third party stuff) is the way it connects data (fields) to the form controls. On each window (form) you drag and drop cache control (sort like drop a class or activeX on to a form) and then draw a line from cache control to the edit control. That sets the read,write, etc.... up. Then you tell the control how to get the data and thats it. Very similar to a datasession in a small sense. Actually, it reminds me more of the Delphi IDE way setting up data access. Next step try to write something!

John