- Microsoft OLE DB Provider for ODBC Drivers Error '80004005' -- DSN Not Found...
The information in this article applies to:
MS Access Databases
ODBC Driver Errros
DSN Not Found
-
- Description:
- I have created a project on my Web server's root using Visual InterDev. I have uploaded the Access database that the project will use. When I try to view the pages that are calling on the database, I receive the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/project/default.asp, line 26
- Solution:
- When you are connecting to a system DSN using Visual InterDev you need to make sure that you have created the system DSN that the code is calling upon in two places:
- Your local computer
You would create the system DSN on your local computer with the ODBC Data Sources option that is located in the Control Panel.
- The Web server
You need to request the DSN be set-up on the server by contacting Re-invent Support.
If you have created the DSN, Microsoft recommends not using many spaces in the connection string:
DSN=MYDSN;Database=Personal;
For more information on this error message read Microsoft's Q183060 -- INFO: Troubleshooting Guide for 80004005 & Other Error Messages knowledge base article.
Article ID: 77, Created On: 5/15/2008, Modified: 5/15/2008