| Author |
 Topic  |
|
|
jhoddinott
Starting Member
United Kingdom
5 Posts |
 Posted - 03 August 2000 : 06:12:56
|
Hi,
I am pretty new to asp, but have had the 'asp-dev forums' up and running on our intranet for some time now.
I am planning to move over to the Snitz Forums 2000 as soon as I can get them properly set up. I have installed the forums on our server, and I as webmaster have had no problem in accessing them. However, when normal users attempt to access the forums they get the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.
/john/asp/snitz/inc_functions.asp, line 518
I have put the snitz_forums_2000.mdb file in the same folder as I currently use for the asp-dev forums [/forum/db] (because I know that users have the correct access permissions set for it). However the rest of the snitz forums are in a different folder [dev/john/asp/snitz] Any ideas as to why it is not working?
Another less critical problem, I want to use the stars to indicate user rankings, but despite selecting them from the config page, they do not appear on the forums. Again any ideas greatly appreciated.
Can't wait to get these forums up and running!
John< |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 03 August 2000 : 07:38:07
|
You've got a permission problem. Make sure the mdb file itself allows everyone to read/write to it. That should fix your problem...
Dave Maxwell
--------------
Self Certified Snitz Bug Swatter  < |
 |
|
|
jhoddinott
Starting Member
United Kingdom
5 Posts |
Posted - 03 August 2000 : 09:00:50
|
Well, I don't really know why, but it works!
I simply extracted a clean copy of the mdb file from the zip file I downloaded, and hey presto it works. I must have messed up the permissions somehow when I was fiddling with the database.
Still no joy in getting stars to show though, but I am happy enough for the moment.
John< |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 03 August 2000 : 09:30:18
|
You went into the Rankings part of the admin section and have the Show Ranking: set to Stars only or Rank and Stars, right?
I'm just asking because there have been times I've gone in there and set every level with a color star and forgot to set the show ranking part....
Dave Maxwell
--------------
Self Certified Snitz Bug Swatter < |
|
|
|
jhoddinott
Starting Member
United Kingdom
5 Posts |
Posted - 04 August 2000 : 04:42:21
|
Yes, I have tried both rank and stars and stars only. The rank shows when selected, and doesn't when not - so that works. But no sign of stars at all. I assume that I don't have to put them in a sub-folder? At the moment all of the icon files are in the main directory, but as the folder and other icons display correctly I assume that the stars are in the correct place.
John
Edited by - jhoddinott on 04 August 2000 04:51:51< |
|
|
|
jhoddinott
Starting Member
United Kingdom
5 Posts |
Posted - 04 August 2000 : 11:30:39
|
Well I think I have worked this one out by myself.
No star shows up next to the new user (despite selecting one from the ranking configuration page)
However, once users make it to the next rank, a star appears!
One very happy user
John< |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 04 August 2000 : 12:12:00
|
DOH! That's right....You need to have the minimum amount of posts (usually 20) before you get to see the first star...Sorry, I forgot about that.
Dave Maxwell
--------------
Self Certified Snitz Bug Swatter < |
|
|
|
heptite
Average Member
USA
547 Posts |
|
|
SirAjh
Starting Member
USA
28 Posts |
Posted - 20 June 2003 : 17:32:21
|
It also may be a problem way back to win you were doing the connection strings. Maybe you have do the the older version of access string instead of access 2000.
Just a suggestion.< |
"Do not try to stand, for I will knock you back down"
--NoFx Clan Webmaster-- |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 20 June 2003 : 17:40:07
|
quote:
Originally posted by SirAjh
It also may be a problem way back to win you were doing the connection strings. Maybe you have do the the older version of access string instead of access 2000.
Just a suggestion.
 3 years late  < |
|
|
| |
Topic |
|
Installing on an intranet
