PDA

View Full Version : Code : 80004005


Squall
08-19-2003, 07:18 PM
Well, i`m trying to set up my own forum on my site, which is coded in the .asp language.(Active Server Page). Sadly, I know little to nothing about Active Server Page. I keep getting this error message whenever I try to open the setup.asp file in my file manager.

The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.



Code : 80004005

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

It`s starting to get very annoying, whenever I think i`ve corrected a problem in my config.asp file, I get yet another error message after trying to access the setup.asp file. Can anyone help me with this annoying problem?

Roy Sinclair
08-19-2003, 07:34 PM
So where is your database and what it the connection string you are using (**** Replace any user id and/or password in that string with some other values, you should never post either of those values in public :) ****).

photoman
08-20-2003, 08:10 PM
Here is the answer to your problem the answer was very easy to find what i did was copied your error code and pasted it into a search engine (google) It gave me the answer on the first page of results.
Common Microsoft error messages expland


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.