 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / Flash / Data Integration / October 2007Problem with Macromedia's example 'rdbms-asp2'
Hi, From Macromedia's site I downloaded an example on how to work with ASP + Flash + Access. The data is correctly being imported to the list, but when I try to add a new record and following update the information to the Access database I receive a message saying: <?xml version="1.0"?><results_packet transID="IID55506635597:Thu Jul 21 09:54:33 GMT+0200 2005"><operation op="insert" id="IID56772432709" msg="Operation must use an updateable query./insert into Contacts (phone,email,name) values('999-111-555','kim@bas.com','Kim Bassinger')"><field name="contactid" curValue="120" /></operation></results_packet> I have tried to figure out what the problem is, but I am stuck. Thus any help is highly appreciated. For your information: I have worked with this can of data integration for a short period only thus not being an expert. The example/ tutorial was downloaded from: http://www.macromedia.com/devnet/mx/flash/articles/flashpro_asp.html Best regards I had this same message. I dont know if this message has multiple meanings but it means you dont have write permissions in your database/folder. Take off simple file sharing, and set the permissions so everyone / IUSR_MACHINE has full control. Thank you for the reply - highly appreciated. I got a bit confused about the Properties for the Access file and how to ensure the correct set-up when trying to solve my problem. So, could you by any chance tell me in details how I can solve the problem ? After reading your reply I have read somewhere that I should contact the web host/ provider and ask them to make the folder writeable (that is the folder including Access database) ? Not necessary or ? /best regards Ok. When I got this message, it was because the file/folder which contained the database was read only. In order to call the update query, the database has to have write permissions. There are multiple ways to accomplish this on a windows machine / IIS console. Also you need to look at alot of different things when deciding how to set up you permissions for the best security. First method (generally works): Goto IIS Console, select your website, select the folder with the database, goto properties, find permissions for the folder, select write. (Or you could just set the properties of just that file by viewing its properties instead). Second method: Disable simple file sharing / permissions. Under folder options of any folder, scroll down to find the checkbox with 'use simple file sharing (recommended)' and un check it. Now return to the database folder and select 'sharing and security'. Share the folder (you can unshare later after you set permissions). Now give everyone the 'full control' permission and also (if availible as users) give IUSR_MACHINE and SYSTEM full control. (once again, can be done on the file itself and not the whole folder.) Side notes: these methods fix the folder write permissions, but don't always work if you have custom permissions. Make sure that the access database (In access) has permissions for the user you are using to connect with. If you are using an ODBC connection, you should verify that the permissions for it are also correct. Basically in summary, every server's permissions are different. Hope that this provides help! =) Thanks for your answer. That was precisely what I was looking for. My problem has now been solved ...........and my IT knowledge expanded sligthly.......thank you ! best regards No problem, glad I was able to help out =). Can you tell me why, when i use your sample files, the flash application tell me that there is a parse error with the .asp file? here's what flash returns: "Connector STATUS - Contacts_xmlcon/Fault/XMLConnector.Results.Parse.Error/received data had an XML parsing error -6" Thank you very much Vince Please does anyone know the solution to the -6 error message as previously requested by other users, this error is due to of the xml string not paired off properly, but i can't find where the error is, and wonder if it really is an error as other people are getting it too. Thanks Debonai From http://www.google.co.uk/search?hl=en&q=RDBMS-ASP2&btnG=Google+Search&meta Posted via DevelopmentNow.com Group http://www.developmentnow.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.