|
heptite
Average Member
USA
547 Posts |
 Posted - 06 August 2000 : 18:45:16
|
Question: I receive the following error message when I try to open default.asp in my browser:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/forum/config.asp, line 49
What am I doing wrong?
Answer: This message means you haven't told the application where your database is located, and what kind it is.
The default.asp file comes with several connection string, all of which have been commented out. You need to uncomment out the one that fits your database type, and edit it to match your database location.
The Access database that comes with the forum a Microsoft Access 97 database. You can usually use the following connection string to get this working:
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\forum.snitz.com\snitz_forums_2000.mdb" '## MS Access 97
NOTE: Be sure you remove the ' character at the beginning of the line.
You'll need to find out where your database is stored, or you can use:
strconnstring = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("snitz_forums_2000.mdb")
You'll have to have the .mdb file in the same directory as the rest of your files to make it work.
If you have any more questions on this topic, please post in the General forums, and we'll add more to this FAQ.< |
|
Troubleshooting Connection Problems
Forum Locked
