Faruk,

I have a DNS service, the problem is that I dont know how to do the connection string.

A string like this works with no problems.

DRIVER=SQL Server;SERVER=xxx.xxx.xxx.xxx;UID=unsername;PWD=userpasword;APP=Microsoft Visual FoxPro;WSID=NCC1701;DATABASE=lineage

But how do I use a domain name on the connection? I’ve tried this.

DRIVER=SQL Server;SERVER=www.domainname.com;UID=unsername;PWD=userpasword;APP=Microsoft Visual FoxPro;WSID=NCC1701;DATABASE=lineage

And

DRIVER=SQL Server;SERVER=http://domainname.com;UID=unsername;PWD=userpasword;APP=Microsoft Visual FoxPro;WSID=NCC1701;DATABASE=lineage

And

DRIVER=SQL Server;SERVER=domainname.com;UID=unsername;PWD=userpasword;APP=Microsoft Visual FoxPro;WSID=NCC1701;DATABASE=lineage

And they don’t work.

so my question is how do I use a domain name to connect to SQL.

Bernardo



>Try these web sites, they provide free DNS services:
>
>http://www.no-ip.com/
>
>http://www.dynu.com/
>
>http://www.dyndns.org/
>
>http://www.dynip.com/
>
>Thanks
>
>Faruk