Try to install the latest MDAC version from
http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en>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
--sb--