George,

The error I get is "Can't Find Server".

The Security is regular security letting the SQL server handle logins. I have access on one development machine, but on the other machine where I transfer the completed program to for testing is where I cant get it to find the server. The ODBC setup is EXACTLY the same (Believe me I have checked several times). There may be a missing file but it there is I do not know what it is or how to find which is missing. I've installed ODBC from the VFP CDROM, and the new ODBC drivers avail from microsoft.

I have a unix box setup at home with a dedicated connection. I go through that for access to the server. Again, on the dev machine there is no problem reaching the server and doing the operations, its on another machine (Same network at home) that I can't get it to find the server on. Thanks for any other insights you or anyone else may be able list....

Gary

>What type of error are you getting when the application tries to reach the server? Is it a connection time-out or something else?
>
>What type of security are you using on SQL Server? Make sure that the user trying to log in has the proper rights on SQL server. If you are using a trusted connection and the user doesn't have access to the database you can get a connection error.
>
>You mention a shared connection to the internet. Is this SQL Server not on your local network or running across a leased line (if located on a WAN)?
>
>Sorry I can't be of much more help.
>