| Author |
 Topic  |
|
|
Hikaro
Starting Member
5 Posts |
 Posted - 07 December 2005 : 23:34:28
|
I know you get this question alot as I have searched on the error, but after reading the posts I have found no definitive answer... So I offer myself up for abuse in asking the question again.
I have never ran a forum, so be gentle.
Upon running the setup.asp file I recive the following error:
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
I have seen many postings with this error so I have checked both permissions of the file and directory path, as well as tried many different connections strings:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../CGI_Bin/DATA/H72YFRM.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/CGI_Bin/DATA/H72YFRM.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\StoneBridge\CGI_Bin\DATA\H72YFRM.mdb" '## MS Access 2000
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/CGI_Bin/DATA/H72YFRM.mdb") '## MS Access 97 using virtual path
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=G:\StoneBridge\CGI_Bin\DATA\H72YFRM.mdb" '## MS Access 97
I have set the database type to:
strDBType = "access"
I have renamed the provided MDB to H72YFRM.mdb
I have set it's security (Permissions) to:
IUSER (Modify, Read, Write, Excecute)
EVERYONE (Modify, Read, Write, Excecute)
The Directory Tree: (G:\StoneBridge\CGI_Bin\DATA\H72YFRM.mdb)
DATA and CGI_Bin
IUSER (Modify, List, Read, Write, Excecute)
EVERYONE (Modify, List, Read, Write, Excecute)
I'm not sure what to try next. I am serving my own site locally on a Windows 2003 server, I am new, my previous site Hikaro.sytes.net shows my meager (and I mean meager) talent.
Any Ideas?, I have also probably given to much permission away so any advice there would also be helpful. Please help, as I'm trying to set up a Forum for my neighborhood.
Thanks in advance. |
Lessons learned from failure are the best rememberd. |
|
|
Hikaro
Starting Member
5 Posts |
Posted - 07 December 2005 : 23:38:27
|
One more note... When I run the WhereamI I get the wrong location:
Where Am I?
Physical Path to Database: G:\StoneBridge\Forum\H72YFRM.mdb
Example strConnString:
This one will work with either Access97, Access2000 or Access2002:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\StoneBridge\Forum\H72YFRM.mdb" '## MS Access 2000
Use the following only if you can't get the first one to work
One reason could be that your host doesn't have the MSJet Drivers installed:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=G:\StoneBridge\Forum\H72YFRM.mdb" '## MS Access 97
|
Lessons learned from failure are the best rememberd. |
 |
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 08 December 2005 : 04:53:40
|
As I remember it you place the whereami.asp in same folder as your db and then it cannot give you anything else but the location of the db. Couldn´t it be that you have put the db in wrong folder? (I hope that the path above is not the correct one, in that case anyone could download your db.)
I use two folders in my root directory; ../forum and ../data and use this with sucess:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../data/xxxxxxxxxx.mdb") '## MS Access 2000 using virtual path
|
rf/www.avgifter.com |
Edited by - Roger Fredriksson on 08 December 2005 05:04:25 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 December 2005 : 07:01:02
|
I'd say it's quite clear that your connection string should be:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\StoneBridge\CGI_Bin\DATA\H72YFRM.mdb"
I would also advise you to change the DB name, now that you've posted it here. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 08 December 2005 : 08:49:42
|
Ruirib, ok but doesn´t this tell us that the db is in wrong folder or does it only tell us that wherami.asp is in wrong folder? :
quote:
Originally posted by Hikaro
One more note... When I run the WhereamI I get the wrong location:
[i]Where Am I?
Physical Path to Database: G:\StoneBridge\Forum\H72YFRM.mdb
|
rf/www.avgifter.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 08 December 2005 : 09:35:28
|
| Roger and out ;) |
rf/www.avgifter.com |
|
|
|
Hikaro
Starting Member
5 Posts |
Posted - 08 December 2005 : 23:41:03
|
Hello Gang, thanks for the response, it was great!
I moved the whereami.asp and it did say I should be using the string ruirib suggested. I have modified the config file with that setting. But I'm still a no go, same error message as before. Could I not be setting permissions right? |
Lessons learned from failure are the best rememberd. |
|
|
|
Hikaro
Starting Member
5 Posts |
Posted - 09 December 2005 : 00:13:01
|
Update, changed the name of my database file as instructed, but didn't update the string. I told you I was a Noob!
Now, in fear that I have given away to much permission with the Everyone and the IUSER... What rights should I give the users to the Data directory path and the Forum directory path.
 |
Lessons learned from failure are the best rememberd. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Hikaro
Starting Member
5 Posts |
Posted - 09 December 2005 : 23:46:24
|
| Thanks Ruirib, this noob is making progress... |
Lessons learned from failure are the best rememberd. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 12 December 2005 : 05:55:00
|
| Hikaro, we were all newbies once ;-) |
|
|
|
spyderuk
Junior Member
United Kingdom
211 Posts |
Posted - 02 January 2006 : 09:44:09
|
| Hmm this sounds familiar but I'm trying to host myself. I think I've got it sorted because I'm not getting the usual error messages but it goes no further on the setup. It just sits there for 10 minutes or so? |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
 Next Mod? My Snitz Forum 
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
