>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.
When the workstation can't see the SQLServer on the network, this usually has to do with the network dlls. Get the SQLServer CD and run setup on the client machine(s). Install the client utilities. This will put all the proper network dlls on the machine. Then use the SQL Client Configuration Utility to set the network library.
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
