Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



Reply
Must use an updateable query ??????
Old 09-01-2005, 06:04 AM Must use an updateable query ??????
numbenator's Avatar
Webmaster Talker

Posts: 534
Location: London
Trades: 0
Hi ,

The below code

Code:
strSQL2 = "INSERT INTO commentsA (studentName,studenteMail,portal,referal,comments,entryMonth,reason) VALUES ('"&iRS("studentName")&"','"&iRS("studenteMail")&"','"&iRS("portal")&"','"&iRS("referal")&"','"&iRS("comments")&"',"&iRS("entryMonth")&",'"&iRS("reason")&"')"
		Set kuUpdate = Server.CreateObject("ADODB.Connection")
		kuUpdate.Open Conn 
	(line 27)	kuUpdate.Execute strSQL2
		kuUpdate.Close
		cnt=cnt+1
is producing the below error

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/webwork/Student Space/archive-action.asp, line 27

Could someone better explain this please

cheers.
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
 
Register now for full access!
Old 09-01-2005, 09:44 AM
ExpressoDan's Avatar
Ultra Talker

Posts: 317
Name: This Space for Rent
Location: Georgia
Trades: 0
Have you ever been able to successfully perform an update on this particular database? If not then it probably has something to do with the fact the windows user "IUSR" has insufficient rights to "write" to the folder containing the database. Check out your permission, if the IUSR has the proper access, it may be something else.

D
ExpressoDan is offline
Reply With Quote
View Public Profile Visit ExpressoDan's homepage!
 
Old 09-01-2005, 09:57 AM
numbenator's Avatar
Webmaster Talker

Posts: 534
Location: London
Trades: 0
yeah , I have actually just overcome problem.
Database had permissions set but server required additional setting in IIS as using ASP.
Cheers for you input though.
Steve
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
Old 09-02-2005, 01:02 AM
PremiumHost's Avatar
Average Talker

Posts: 23
Trades: 0
Right click on the database and change permission.
Most Windows hosting set correct permission for your database.
Mostly the error occurs on localhost ;-)
__________________

Please login or register to view this content. Registration is FREE

Proudly to be a reliable host for 5000+ domains
Linux Reseller Cpanel 11 - Windows Reseller Helm ASP.NET 3.5 SQL 2005
PremiumHost is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Must use an updateable query ??????
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.18330 seconds with 11 queries