Microsoft IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > System Administration > Microsoft IIS
Reload this Page

Problem with delete and insert into statements

Discuss Problem with delete and insert into statements in the Microsoft IIS forum on ASP Free.
Problem with delete and insert into statements Microsoft IIS forum discussing Internet Information Server general usage, including configuration and server set up. Get the most out of the most popular web server for Windows.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 27th, 2005, 06:41 PM
amasmm amasmm is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 86 amasmm User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 h 42 m 15 sec
Reputation Power: 4
Problem with delete and insert into statements
Currently, I am developing a website using asp technology and access database ... I work on two computers, and IIS is installed in both of them, in the first computer everything is working fine, but when I use the second computer I get some errors where my code have delete statements or insert statements. the errors are:

For delete statement I get:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/eschool/attendance.asp, line 13

For insert into statement I get:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.

With other computer I dont get these errors and everything is done in correct way ... therefore, I thought that I have to adjust my IIS settings in the second computer but I dont know which ... can anyone help me?
Reply With Quote
  #2  
Old November 27th, 2005, 10:33 PM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
ASP Free God 16th Plane (12500 - 12999 posts)
  
Join Date: Feb 2005
Location: Dreamland
Posts: 12,867 mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 4 Weeks 15 h 21 m 57 sec
Reputation Power: 1762
check the permissions for your database as well as the IUSR_<machinename> on the computer where it's not working.
__________________
Come JOIN the party!!!

Quote of the Month:
Retirement: Because you've given so much of yourself to the company that you don't have anything left we can use.

Questions to Ponder:
What do you do when you see an endangered animal eating an endangered plant?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69
Reply With Quote
  #3  
Old November 28th, 2005, 12:06 AM
Guddu's Avatar
Guddu Guddu is offline
Contributing User
Click here for more information.
  
Join Date: Jul 2005
Location: Oxford UK
Posts: 3,677 Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level)Guddu User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 2 Days 20 h 4 m 9 sec
Reputation Power: 798
vist this......
for database permission
http://www.webwizguide.info/asp/faq/server_permissions.asp
__________________
Nothing is Impossible bcoz IMPOSSIBLE itself says..
I M POSSIBLE........................
 Be cool !!!!!!!!
Reply With Quote
  #4  
Old November 29th, 2005, 05:21 PM
amasmm amasmm is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 86 amasmm User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 h 42 m 15 sec
Reputation Power: 4
how can I check the database permissions? GUDU your link does not help me ... I have another version of IIS ... thanks anyway
Reply With Quote
  #5  
Old November 29th, 2005, 05:34 PM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
ASP Free God 16th Plane (12500 - 12999 posts)
  
Join Date: Feb 2005
Location: Dreamland
Posts: 12,867 mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 4 Weeks 15 h 21 m 57 sec
Reputation Power: 1762
to check the database permissions ...
go to the directory where the database resides
right click on database and click properties
check security ... make sure the database has read and write access for the IUSR_<machinname> account

also try doing the same to the directory that holds the database ...

the link that guddu gave should work on any IIS Server from NT4, 2K, 2K3, XP

you also need to go into IIS and check that
Reply With Quote
  #6  
Old November 29th, 2005, 10:20 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 19 m 36 sec
Reputation Power: 181
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #7  
Old December 5th, 2005, 10:53 AM
amasmm amasmm is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2005
Posts: 86 amasmm User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 h 42 m 15 sec
Reputation Power: 4
Finally I fixed the problem by giving my pc another name ... thanks guys for your assistance
Reply With Quote
  #8  
Old December 5th, 2005, 11:41 AM
elijathegold's Avatar
elijathegold elijathegold is offline
Senior Fire Wizard
Click here for more information
 
Join Date: Feb 2005
Location: Ashford, Kent. England
Posts: 5,651 elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)elijathegold User rank is Captain (20000 - 30000 Reputation Level)  Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4Folding Points: 1721622 Folding Title: Super Ultimate Folder - Level 4
Time spent in forums: 2 Months 2 Weeks 2 Days 4 h 21 m 19 sec
Reputation Power: 301
As it may help me work out if I am having my chain yanked...

Did it have an _ (underscore) in the name?
__________________
And he picked it all up... in his pick-up.





Friends of Shemzilla
Reply With Quote
Reply

Viewing: ASP Free Forums > System Administration > Microsoft IIS > Problem with delete and insert into statements

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway. 
Stay green...Green IT