ODBC: error conecting to SQL Server

[Sergio Florez M.]

I have an Access front-end that has a SQL Server back-end. It is installed
on 20 PCs in my company. Someone installed some software in one of these PCs
and now that particular computer gives me the error when opening the Access
front-end.

ODBC: error conecting to SQL ServerMyServer

 

[Van T. Dinh]

If you use (ODBC) DSN then check the settings of the DSN. There is a Test
button in the DSN Dialog that you can test accesing the SQL Server database
from the problematic machine.

If the DSN is OK, try copying a fresh Front-End to this machine.

 

[Sergio Florez M.]

I was trying to do this but the problem is that SQL Server isn't there in
the DSN drivers list. It's usually the last one. I installed MDAC 2.7 just
in case but nothing happened. SQL Server still doesn't show up.

--
Sergio Florez M.
Miembro activo www.AlianzaDev.net
El que persevera insiste
Medellín, Colombia
DCE 4

 

[Van T. Dinh]

Do you mean the MS SQL Server ODBC driver is no longer available for
selection in the ListBox?

If that the case, you may like to try repairing (???) the Win OS. You may
also need to post in the suitable Windows newsgroup on how to repair /
restore the (MS SQL Server) ODBC driver back to the OS.