| Author |
 Topic  |
|
|
KenDude
New Member
USA
87 Posts |
 Posted - 01 March 2001 : 10:22:58
|
First, I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Forum2/inc_functions.asp, line 644
Which would lead one to believe that it is a directory security issue on my "Forum2" directory right? WRONG!
Here's what I did, try this yourself if you like.
I renamed Default.asp to Defaultbak.asp, Frontpage asked me if I wanted to update the links to the new page and I said "No". I ceased to run the forum for a day. I renamed Defaultbak.asp to Default.asp
AND NOW I GET THE ERROR ABOVE!
I haven't touched directory security on my server! In fact I am logged in as the admin right now and I still get the error!
Can anyone help? Can anyone else duplicate this problem?
I know someone is going to ask for it, so here's the line from my config.asp file:
'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetpub\spyder\fpdb\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
Until I get this fixed, I am down, so it makes it rather critical. Thanks!
KenDude was here!
|
|
|
KenDude
New Member
USA
87 Posts |
Posted - 01 March 2001 : 10:32:44
|
Something else I should point out, I have other databases in that directory and I can read and write to them just fine, so again, it isn't directory security. It could conceivably be file security, but I haven't changed anything with the file or file security either. The only changes I made are listed above. This shouldn't happen!!!
AAAAAAAARRRRRRRRRRRRRRRGGGGGGGGGGHHHHHHHHHH!
KenDude was here!
|
 |
|
|
KenDude
New Member
USA
87 Posts |
Posted - 01 March 2001 : 10:46:20
|
BTW, I can log into the "Admin Options" of the Forum and look at the configuration and it looks fine, but if I try to save the config I get a similar error, although this time in the file /Forum2/admin_config_system.asp, line 114
The offending line, just like the other file is:
my_Conn.Execute (strSql)
KenDude was here!
|
|
|
|
KenDude
New Member
USA
87 Posts |
Posted - 01 March 2001 : 11:13:20
|
I fixed it, and here's how:
I looked at my database connections in Front Page and went to test one of them. It told me that it was broken because it was pointing to some directory that didn't exist. So I repaired that link. Now this was a connection for another database, NOT the Snitz database.
What it did was do "something" magical to my global.asa file in the root dir of the website. After these changes were applied, the Snitz forum magically started working again!
So just to be clear, it wasn't a file or directory security issue other than something in FrontPage was causing the global.asa to point someplace it shouldn't, I guess. As I said, really weird, but I have it fixed now. If you run into the same problem, you might also look to your Global.asa file as a possible culprit in these circumstances...
Oh yeah, and don't change file names in Front Page! 
KenDude was here!
Edited by - KenDude on 01 March 2001 11:14:24 |
|
|
| |
Topic |
|
|
|
Topic Locked
