I'm trying to set up ODBC connections for a FoxPro application on many workstations on a Windows NT network. On most workstations, the ODBC Administrator works fine but on a few I just can't get it to work.

I start the ODBC connection program from the Control Panel, then select the "System DNS" tab, select "ADD" and then the "SQL Server" choice and on the next form assign a name and then try to select the server. However, when I select the drop down box that generally gets populated with the list of available servers, I see nothing but "local." I've tried typing in the name of the Server and it does let me go to the next step but the connection always fails.

Is there anything that needs to be "turned on" that allows the workstations to see the servers so the list box will be populated?

All of these workstations are of the same type PC's, share the same domain that the SQL server is on and use the same logon to the domain. I can set up the ODBC connection on most workstations but some are giving me the problem described above.

Any ideas on things to check would be greatly appreciated.

Robert Wright