SQL Server 2000 Client won't connect
- by alimack
One day instead of connecting to the database my SQL Server Management gave me the following error:
"Data Source name not found & no default driver found"
Note it had been working for several years before this, all that had changed was an upgrade to Office (97 -2000) and the monthly Windows patches.
I tried rebooting, re-installing both the SQL Server 2000 and 2005 clients on the machine but no joy. I can access the database(s) from other machines.