You cannot do this with a VFP ODBC driver. Even if is called "remote view", all processing is done by client workstation. (VFP ODBC driver doesn't connect to a server, but does itself the entire processing - open database and tables, execute SQL commands, etc). The database and tables must be in a shared folder from server. I've tried another solution, an ODBC to ODBC bridge server and client(EasySoft) but was slow . And finally, I've downloaded and installed a free database server. I'm using it right now and I don't want to go back.


>Thanks Aashish
>
>what I am looking at is the exe in the client do not open tables anymore but use sqlconnect().
>
>the DNS/ODBC has already been set at the server.
>
>the purpose is to hide the databse from the client so that it cannot be copied/seen from explorer by client.
>
>this concept is like html pages requesting data but completely disconnected from the database. the server does all the serving of data.
>
>the client does not need setting up dns. just passing the sqlconnect() should be enough to get data.
>