Hi Doug!
Thanks for the direction.
Tony

>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