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.

George
>Hi,
>
>I am using 32 bit ODBC drivers for SQL (2.65).
>I can ping the server either by name or IP, name resolving is being done.
>Downloaded and installed the latest SQL driver ... Didnt work...
>Installed ODBC from my VFP 5.0a disk on that machine...Didnt work...
>
>I'm really at a loss here, as to why it would work on one machine and not the other and thier setups are identical and they are on the same network using the same shared connection to the Internet.
>
>Thanks for the pointers.
>
>Gary
>
>>>
>
>>Don't know if I can answer this but here are a couple of things to look at:
>>1. Are you using 16 or 32 bit ODBC drivers?
>>2. Can you ping the SQL server from the PC that you are installing the app upon?
>>3. You may want to download the latest ODBC drivers from M$ and use these drivers on all machines that will run the app.
>>
>>HTH