Hi!

You can use either DSN or IP address instead of server name in the connection or connection string.

However, this approach is not very reliable way of data sending from certain points of views. It is better to use some sort of services at the server side. HOW you transfer data is dependent on the services you create (FTP, HTTP, email, SOAP, DCOM etc.)

XML is just a format of data and does not matters here, for example, you can update data on W2K server through Internet either by direct (usual) way or by XML. OR, you can send data as XML (or any other format) and your services will update data as they receive them on the server.



>Hi,
>My app is a Fox 6 application. I want to connect to a SQL Server 2000 database over the web and send the day's summary to this server.
>
>How do I connect to the SQL Server? Can I use a DSN if I know the IP of the server? Do I use XML?
>
>Please help
>
>Abdul Ahad