| Author |
 Topic Search  Topic Options
|
MarjaR 
Newbie
Joined: 12 December 2003
Status: Offline
Points: 14
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 12 December 2003 at 2:48pm |
Same error with relative paths (the Server.MapPath method)
|
 |
thekiwi
Mod Builder Group
Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:07pm |
 MarjaR wrote:
Hi,
I just uploaded the forum files to my website and tried to login with the Administrator account. However, it's not working.
The error is the infamous 'updateable query' error, but I'm very certain that the directory where I put the forum database has the proper access rights, because my regular website database "lives" there as well.
I'm positive (checked, double-checked and re-checked again) that I've changed the 2 common.asp files so that the DB path looks like:
strDbPathAndName = "d:\www\flevooware.nl\database\wwForum.mdb"
And I know for certain that I've uploaded them as well.
So what else could be wrong?
Regards, Marja
BTW. the forum is located here: http://www.flevooware.nl/dreamweaver/forum/
|
This is almost always a permissions issue.
Be sure that the MDB file is in a folder where IUSR has read/write access (because IUSR_<machine_name> needs to create an .LDB file when modifying the database).
Also be sure that the MDB file itself isn't marked as read-only, and that you don't have the MDB file open (particularly in exclusive mode) while trying to reach the DB from ASP
|
|
|
|
thekiwi
Mod Builder Group
Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:09pm |
MarjaR wrote:
This database directory is outside the website root and is thus a safer place for a database.
|
Yes ..... it should almost be "required" that the database is moved outside the scope of the WWW Site. Sure renaming it is a good idea .... but nothing is more secure than it being almost impossible to "reach" for download.
|
|
|
|
MarjaR
Newbie
Joined: 12 December 2003
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:15pm |
I placed the WebWiz MDB file in the same directory as where my main website MDB file resides.
And I have no problem whatsoever updating my website DB using my CMS.
I've tried re-uploading the forum DB several times now (to try to make sure it wasn't corrupted in the FTP process), but it doesn't help.
|
|
thekiwi
Mod Builder Group
Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:18pm |
MarjaR wrote:
I placed the WebWiz MDB file in the same directory as where my main website MDB file resides.
And I have no problem whatsoever updating my website DB using my CMS.
I've tried re-uploading the forum DB several times now (to try to make sure it wasn't corrupted in the FTP process), but it doesn't help.
|
Yes ... but that doesn't 100% ensure that the database itself is read/write. The only 100% way to ensure this (trust me .. I run a hosting service and it happens often) is to TermServ in or be at the console and chekc the privs of the MDB file.
|
|
|
|
MarjaR
Newbie
Joined: 12 December 2003
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:22pm |
thekiwi wrote:
Yes ... but that doesn't 100% ensure that the database itself is read/write. The only 100% way to ensure this (trust me .. I run a hosting service and it happens often) is to TermServ in or be at the console and chekc the privs of the MDB file.
|
Okay, but this site is externally hosted so I can't do what you describe here.
I've checked the MDB file properties here locally before uploading it and it isn't read-only here on my computer.
Can it become read-only in the FTP process?
|
|
thekiwi
Mod Builder Group
Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:23pm |
shadow man wrote:
you're only supposed to change the name of the database. |
No you're not
http://www.webwiz.net/web_wiz_forums/docs_access_move_d b.asp?mode=forum
"For higher security it is highly recommended that you at the very least rename the forum database and if possible move the location of the database to a folder above the root directory of your web site where it can not be accessed using a web browser, good web hosts will have a directory set up for this usually called private. (If you don't you leave yourself wide open to hackers!!)"
|
|
|
|
shadow man
Mod Builder Group
Joined: 11 December 2003
Location: United Kingdom
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 December 2003 at 3:29pm |
|
sorry about that...
|
|
|
|
