In the test environment (2 IIS web servers, 1 SQL server, 1 IIS Utility server) none of our DB-driven apps are working. We cannot figure out the issue, but we think that MDAC is hosed.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.