i remember this as well. my CEO had the same problem (he dabbles in programming).
make sure IUSR_MACHINENAME has write perms to the directory in which the MDB file resides. it needs them to create the LDB file. this is, of course, if you have anonymous access enabled. if you search MS's site, they give 4 or 5 possible solutions to this problem. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:59 PM To: CF-Talk Subject: RE: weird insert/update error just right click on the database file you copied over. make sure the web client or what ever your server calls it has read/write privileges to the db. that's it. -paul -----Original Message----- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:44 PM To: CF-Talk Subject: RE: weird insert/update error I am receiving the same error message after migrating an app from my laptop (wok, CIF, Silk) to our dev box (same). Can you tell me what permissions needed to be reset/set? All seems to be in order. (I have also checked, per earlier comment, both MAC versions and they are the same (2.6). did this help you at all?) -Craig Thomas -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:23 PM To: CF-Talk Subject: RE: weird insert/update error found the problem.... when i copied the files & the data base to the server, the file permissions where reset. i had to allow web users to be able to write to the database. kind of odd, never ran into this before. should be fine now. -paul -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:50 AM To: CF-Talk Subject: RE: weird insert/update error no. download the MDAC checker from MS (http://www.microsoft.com/mdac) and run it at the server console. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:27 AM To: CF-Talk Subject: RE: weird insert/update error ok. can i do that in cf admin? -paul -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:06 AM To: CF-Talk Subject: RE: weird insert/update error check the MDAC version on the production box. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:31 AM To: CF-Talk Subject: weird insert/update error ok i have this little app. runs just fine on my local host using cf 5.0 server it also runs just fine on our cf 4.51 production server winNT but when i move it to a 5.0 production server that is win2k i get the error below same files, same db, same odbc's... any ideas. thanks -paul Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:26). ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
