My approach is to skip the ODBC setting in Control panel of Windows by creating connection in FoxPro's Project Manager for said "mySQLconnect" with DSN-less connnection string, which may only run once on first start up...
1. You don't want to create SQLStringConnect(???) every time, which is difficult, time consuming, and if there is a change in IP address? oop...
2. When you need connection, just called sqlconnect('mySQLconnect')
3. Easy to manage, since all remote views is based on mySQLconnect, you may also share the connection,
4. You don't need to set cursor to be updatable, which you can use remote view if you need to Send Update to server.
Frankly, with the helps from Sergey, I tried them all (remote view, SQL pass through). I think using remote views for tables need to be updated, using SQL-PT for gather information; however, open connection take time, since remote views keep connection alive, unless you close all remote views with the connection. You should consider it especially when your server is connected with limited bandwidth...
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************