| Author |
 Topic  |
|
|
tomt
Starting Member
7 Posts |
 Posted - 01 June 2001 : 02:45:24
|
I finally got something to show up besides an error page
By using this.
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\websites\bmgamescom\fpdb\snitz_forums_2000.mdb" '## MS Access 97
None of the other strings will even start to work.
But this is also displayed now
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/forum/inc_functions.asp, line 644
I also went into the control panel and turned on the read/write permissions
for my forum folder and my fpdb folder
When I log in as ADMIN there are about 10 line to click on to edit the forum
Settings, but no matter what I try and change then submit nothing changes.
No forum topic is displayed "I assume there is a default test one???" just the register-search etc. in the top right corner.
The FAQ question shows O.K. and the sign up screen but nothing will post right.
Nothing changes !! I can’t even register as a new user!!
Any suggestion . Thanks
|
|
|
BuffyNET
Junior Member
United Kingdom
126 Posts |
Posted - 01 June 2001 : 03:16:37
|
Which verison of the forum are you using?
Do you still receive the Operation must use an updateable query error?
Are you using Frontpage to edit it (I noticed your database dir was fpdb)?
Do you have an url we can see it at or is it setup locally?
Neil
This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
|
 |
|
|
tomt
Starting Member
7 Posts |
Posted - 01 June 2001 : 04:36:56
|
Sorry I put this in the other post reply I was looking at.
http://www.bmgames.com/forum/default.asp
Just change my provider to
hosted by webstrikesolutions.com
because they support everything and we talked and submitted code with this forum on another programming site and it was great, so we wanted to set up a new site for RPG game programming forum.
My provider has a control panel and I enabled Data Base read/write on both the forum directory and the fpdb directory which has the snitz mdb file in it. I will be using front page for the home page later but I did not have them install any front page extensions. I just used an ftp program and made the data base folders and uploaded the original files. The zip which we just downloaded a couple days ago say V3_1_srv4. Got it from your site and other than changing the two lines that the read me say to, nothing has been changed. The admin and admin password are the same because I can't get anything to work yet.
Give a database or directory updateable permissions.
This process gives the NT user 'IUSR' read and write access to any files or directories you specify. It effectively gives a specified file the ability to be replaced or updated by a process such as an ASP script. It is most commonly used for Access Databases.
(Note: this is not the same as giving a regular text file write access)
-- I used this to enable data base permissions on the two folders with the control panel!!!!
The site control panel also has
--But I did not do this option!!!!
This process gives the NT user 'Everyone' read and write access to any files or directories you specify. It effectively gives a specified file the ability to be written over or replaced by a process such as a cgi or asp script.
(Note: this is not the same as giving a database updateable permissions)
Do you think that is my problem, also do these only need to be for the fpdb folder and not for the forum folder. Their help files are typical for people who already know what their doing ..
If you want your more than welcome to go in and check things out. This site isn't really in use yet because the forum is going to be the important part of it.
Thanks for your time and info.
|
|
|
|
BuffyNET
Junior Member
United Kingdom
126 Posts |
Posted - 01 June 2001 : 04:49:29
|
OK, this is in the readme file, so you do need to do the second option on the control panel :
2. The snitz_forums_2000.mdb file needs to be uploaded into a directory where
the directory permissions have been set to read/write, i.e. a cgi-bin/ or
fpdb/ folder. Also, it's advisable to make sure this directory is not
accessible by the web to stop people downloading the database. Bottom line,
set up the "IUSR_YOURMACHINENAME" account (or EVERYONE) to have full control
of that file/directory outside of your web server (most secure).
Edited by - BuffyNet on 01 June 2001 05:45:00 |
|
|
|
tomt
Starting Member
7 Posts |
Posted - 01 June 2001 : 14:00:13
|
http://www.bmgames.com/forum/default.asp
I went into my site control panel and turned on.
This process gives the NT user 'IUSR' read and write access to any files or directories you specify. It effectively gives a specified file the ability to be replaced or updated by a process such as an ASP script. It is most commonly used for Access Databases
Also I went into my site control panel and turned on.
This process gives the NT user 'Everyone' read and write access to any files or directories you specify. It effectively gives a specified file the ability to be written over or replaced by a process such as a cgi or asp script
For both the forum folder and the fpdb folder.
The only script line that would sort of work then was the Access 97 one.
But at least It showed something.
I can see the snitz home- profile-register etc. But below these is only
This error explanation
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/forum/inc_functions.asp, line 644
The admin login and password admin are the same as originally unzipped.
I can view pages to register and admin and FAQ etc. But am not able to
register or change anything or use the forum.
Thank you for your patience and help.
|
|
|
|
tomt
Starting Member
7 Posts |
Posted - 01 June 2001 : 18:09:28
|
http://www.bmgames.com/forum/default.asp
Well the good news is since my forum doesn't work I took about 5 hours and read 21 pages of topics here. You guys are amazing to be able to figure out how to help most everyone.
Sounds like most of them are website server problems. Probably what I have too, but this type of stuff isn't for newbies. Our game programming is easier than this stuff. I'll wait for a day or so and see if anyone can fix me too, else I guess I'll just delete the two folders until I can learn more.
Thanks again
|
|
|
|
tomt
Starting Member
7 Posts |
Posted - 01 June 2001 : 18:21:49
|
!!!!!!!!!Don't know why
BUT IT WORKS NOW. Maybe just didn't wait long enough for everything on there servers to be updated.
!!!THANKS AGAIN !!!!
SEE reading does help !!ha
Edited by - tomt on 01 June 2001 18:23:23 |
|
|
| |
Topic |
|
Topic Locked
