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