We're trying to connect Visual Fox Pro to SQL Server to set up a client server system and are having problems connecting the client.

The connection works on the one workstation that is both client and server but we cannot connect other workstations.

Does anyone have any suggestions or can you refer me to any materials that can assist us in this connection.

Any suggestions would be appreciated.

Thank you.