| Author |
 Topic  |
|
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 03 August 2000 : 16:19:52
|
I just set up snitz forum and received this error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Slackers/inc_functions.asp, line 519
anyone else having this problem?
other notes:
i'm using windows 2000 advance server with access database.
i have configured my connection string right.
The error seems to be the username variable is empty.
when i comment the my_conn.execute(strSql) and do i response.write strsql, the username is empty.
any help will be appreciated.
- Alan
Moving to FAQ Fodder Folder.< |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 03 August 2000 : 16:34:54
|
This probably should be a FAQ topic, it's not an uncommon problem with new installs.
You get this error when the web server doesn't have write access to the .mdb file.
If you're on IIS (Microsoft), and your web allows anonymous surfing, the web server uses the Internet Guest NT user account context (normally IUSR_xxxx, where xxxx is the computer name for the server). This user needs r/w access to the .mdb file.
If your web (that contains the forum code) requires login to NT to gain access to the web, the web server will use the user's account context, in which case the individual user accounts need r/w access to the .mdb file.
======
Doug G
======< |
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 03 August 2000 : 16:39:58
|
wow...quick response =)
Thanks Doug,
I didn't realize that that was the problem. I'll check it out and see.
- Alan
Edited by - aznknight on 03 August 2000 16:47:35< |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 03 August 2000 : 17:04:20
|
Figured it out. the problem didn't actually have anything to do with IIS. When i unzipped the database, It had a read-only property, which can be easily fixed by right-clicking the file and unchecking it. heh =)
funny how that's the default property for the snits.mdb file.
- Alan< |
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 03 August 2000 : 19:27:02
|
quote:
Figured it out. the problem didn't actually have anything to do with IIS. When i unzipped the database, It had a read-only property, which can be easily fixed by right-clicking the file and unchecking it. heh =)
funny how that's the default property for the snits.mdb file.
Then that needs to change. Easy enough to fix.
Sue
<< I am extraordinarily patient, provided I get my own
way in the end. ~ Margaret Thatcher >>
< |
|
|
| |
Topic |
|
setup error
