Here's the error I'm getting:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I dont' know why??? I created a System DNS, tested it successfully. Created a Connection (via Dreamweaver) tested it successfully.

But when I call the page:
I get the error above???

One thing I did notice, my access database creates an "ldb" file everytime I open the page (In dreamweaver)???


I haven't even tried calling a Dynamic table which is ultimately what I'm trying to do.

Please help, as in following the instructions within Dreamweaver I haven't found the solution,
Thanks for all your help!

Nancy

I have found this posting that might help. It is from

Error:
80004005 - Data source name not found and no default driver specified
or
80004005 - Driver's SQLSetConnectAttr failed
or
80004005 - General error Unable to open registry key ‘DriverId’”)

What's it look like?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified

or similar .......



Why Me??
This can happen if .....

   1. The page can’t find the DSN on your local machine.
   2. The page can’t find the DSN on your Web Hosts server.
   3. The DSN was set up as a user DSN, not as a system DSN.
   4. If you are using Microsoft Access, the database file (.mdb) might be locked due to a DSN with a different name accessing the database.

What must I do???

   1. Make sure that you have set up your DSN correctly on your local machine.
   2. Just because you have a DSN on your local machine does not mean that your page will automatically work on your Web Hosts server. You have to set up a DSN (with the same name) on their server as well. Check your hosts FAQ's or mail their support team for instructions.
   3. Check that the DSN you set up was a "System" DSN and not a "User" DSN.
   4. Look 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 delete that DSN to prevent the error in the future. Reboot the computer after making these changes. http://www.webthang.co.uk/forum/code_replies.asp?ID=3944

Thanks but this doesn't help. I'm trying to figure out why my DB creates a locked file EVERYTIME I open Dreamweaver.????

Try this posting from Microsoft. Do you have your DB open? In Access, have you given permissions for read/write to your users? Let us know how this works. Unfortunately, I use MS SQL and am not too familiar with the quirks of Access.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;208778

Download this Powerpoint file. On slide 44, you will see a screen shot of exactly how your permissions need to be set in Access.

[http://www.coba.panam.edu/faculty/cr...S4312/ch07.ppt

Thank you,but this problem has been resolved. It had to do with web-admin stuff. System administrator fixed.

nancy

hi everyone

I am stuck with this problem can anyone help
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed