>Hi there
>I have a stand alone PC XP based on which it is running a VFP application. It has to retrieve data from a remote SQL server database via Internet. Actually I retrive data from a FTP site but seen that we (HE) is transferring the web server onto our PC win 2008 server Based that is located in our office, I was thinking about getting data directly from this PC.
>My question is :) : How to get connected to this database via Internet ?
>
>Thank you very much
>
>Alessio
Alessio,
You can connect using an IP address or URI. For example if that PC could be located as alessio.com then your connections string would look like:
server=alessio.com;uid=username;pwd=password;
or with IP:
server=x.x.x.x\sqlInstanceName;uid=username;pwd=password;
with a port number and specifying the connection library:
server=x.x.x.x,1433;Network Library=DBMSSOCN;uid=username;pwd=password;
Cetin