Hi Tony.

>1. Which is the best way to connect
>to MS Sql server in a LAN and process
>data in a database on it?
>
>2. And if it is in a MySQL server in
>a "site"(domain) at the internet, how
>it can be achived?

The nice thing about using ODBC to access a database is that it doesn't matter what database engine you're using or where it's located. You simply connect using a connection string (using the SQLSTRINGCONNECT function) or a data source name (DSN) you create using the Windows Data Source Administrator (using the SQLCONNECT function) and use the various SQL passthrough functions (such as SQLEXEC).

I suggest one of a couple of books by Hentzenwerke Publishing: http://www.hentzenwerke.com/catalog/mysqlvfp.htm and http://www.hentzenwerke.com/catalog/csvfp.htm. Both go into great detail on using ODBC and SQL passthrough and focus on MySQL and SQL Server.

Doug