80004005--Data source name not found and no default driver specified

This error occurs when you attempt to view a dynamic page in a web browser or in Live Data mode. The error message may vary depending on your database and web server. Other variations of the error message include:

• 80004005--Driver's SQLSetConnectAttr failed
• 80004005--General error Unable to open registry key 'DriverId'

Here are possible causes and solutions:

• The page can’t find the DSN. Make sure a DSN has been created on both the web server and on the local machine. For more information, see Using a DSN.
• The DSN might have been set up as a user DSN, not as a system DSN. Delete the user DSN and create a system DSN to replace it.

  NOTE

  If you don’t delete the user DSN, the duplicate DSN names produce a new ODBC error.

• If you use Microsoft Access, the database file (.mdb) might be locked. The lock might be due to a DSN with a different name accessing the database. In Windows Explorer, search for the lock file (.ldb) in the folder containing the database file (.mdb) and delete the .ldb file. If another DSN is pointing to the same database file, you may want to delete the DSN to prevent the error in the future. Be sure to reboot the computer after making these changes.