Author |
Topic  |
chiefcook
Starting Member
USA
30 Posts |
Posted - 09 August 2006 : 12:20:07
|
Yeah, I am hosting this in-house. I'll do some more research on Windows 2003 and ASP. Thanks for everything. I will Post when I find an answer from this end. |
Everything is easier when it is someone else's responsibility |
 |
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 09 August 2006 : 14:39:25
|
I altered setup.asp in order to try placing the DB in a different directory outside of the web root and I now get this error.
Does this seem a little more "normal" for an error?
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/forum/inc_header.asp, line 110
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
I jsut wanted to see if the permissions might have been screwy on the web root, so I redid my web from scratch and decided to relocate the DB... unhappy users for a while <grin> |
Everything is easier when it is someone else's responsibility |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 09 August 2006 : 15:50:51
|
It's the same kind of error, with what it seems to be a different message. The error still occurs while creating a connection object, which seems weird, I never saw it before. I must admit that my experience with Windows 2003 is quite limited, though. It's a permissions error, nonetheless. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 09 August 2006 : 16:35:13
|
I did some further research about ASP and windows 2003 and it seems that there are alot of others with this type of issue. Unfortunately, none of their resolutions seem to help. I'll with post if I find anything. Thanks for taking the time to help from the software end. |
Everything is easier when it is someone else's responsibility |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 10 August 2006 : 06:04:55
|
I don't have a sandbox to test security patches so they go on this production server within 10 days or so of release.
A lot of the issues seem to revolve around service pack 1. Here is a relative link http://bugs.mysql.com/bug.php?id=9932 It is from 2005...
I have to keep service pack 1. I may be able to throw the forum on a 2k or XP machine if I cannot resolve on 2003 |
Everything is easier when it is someone else's responsibility |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 15 August 2006 : 06:02:48
|
I'll try it. Thanks for the help! |
Everything is easier when it is someone else's responsibility |
 |
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 16 August 2006 : 08:46:22
|
Hey Ruirib! I found the answer!!!! It is in this knowledgebase article KB 315454. I have included the link http://support.microsoft.com/kb/315454. This completely fixed this issue. Now, hopefully I can get the email portion up <GRIN> |
Everything is easier when it is someone else's responsibility |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
RobincMBA
Starting Member
Canada
2 Posts |
Posted - 25 August 2006 : 17:19:12
|
I'm running Windows XP Media Center 2005 with IIS 5.1; no matter what option I select for accessing an MS Access database, when I click on the link to initialize the database, I keep getting 13 Critical errors, all the same: "Error: -2147467259" which is described as "Operation must use an updatable query," even though the details, clearly the queries listed are correct.
I have both MS Access 2000 and MS Access 2003 installed; I have tried using a system DSN, as well as the directory path options in config.asp
Has anyone experienced this? If so, is there something I'm missing?
Thanks for your help in the matter.
|
Sincerely,
Robin L. M. Cheung, BScH, MBA
RobinCheung@rogers.com |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 25 August 2006 : 17:35:47
|
If you try a search using 'updateable query' as the keywords, you will find that the same issue has occurred with a lot of users before. It's a permissions error, you need to assign read / write permissions on the database file and folder, for the anonymous internet user (IUSR_YourComputerName).
Also, you should have started a new topic. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
RobincMBA
Starting Member
Canada
2 Posts |
Posted - 25 August 2006 : 17:44:39
|
Sorry for not starting a new topic; however, I noticed that one difference between XP Pro and XP Media Center (although both use IIS 5.1 I believe), is that the Security and Sharing tabs are not the same; whereas in XP Pro you could select Security | Advanced and add specific users permissions, I cannot locate the same functionality in XP Media Center.
I had suspected it was a permissions issue, but I do not know how to set permissions for specific users in XP Media Center, if there is a workaround, or if it is hidden somewhere else.
Thanks for the prompt reply |
Sincerely,
Robin L. M. Cheung, BScH, MBA
RobinCheung@rogers.com |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
Topic  |
|