Use the IP address of the SQL Serve machine in your connection string:
ConnString = "SERVER=nnn.nnn.nnn.nnn;DRIVER=sql server; UID=sa; PWD=; DATABASE=northwind; Address=nnn.nnn.nnn.nnn,1433; Network=DBMSSOCN"
Where nnn.nnn.nnn.nnn it's the IP of the machine where SQL Server lives. SQL Server listen port 1433.
>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
Hector Correa