flash data integration: 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.

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(&apos;999-111-555&apos;,&apos;kim@bas.com&apos;,&apos;Kim
Bassinger&apos;)"><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

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 !

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
Debonair

From http://www.google.co.uk/search?hl=en&q=RDBMS-ASP2&btnG=Google+Search&meta=

Posted via DevelopmentNow.com Groups