You can only use accounts with priv sets that have the fmxml extended privilege enabled. So check what priv sets those are; do those priv sets allow for record creation and editing?
Forgot to mention that I have fmxml and fmphp enabled (even though fmphp should not be needed the way this is set up).
I am betting that it is an authentication issue on IIS but I can't pin it down and since it is hit or miss on the finds and always a problem on the add record operations it is really getting under my skin.
I had no access into the data until I enabled Basic Authentication and at that point I was not trying to write so I didn't notice this problem until this week.
The authentication dialog sometimes says the file name and some times just says the server name if that means anything to anyone.
When I don't get the dialog on add operations, I just get the attached 200 error
I read what I thought was applicable. I am actually using fx.php and without the basic authentication, it wasn't allowing anything to flow to the other web server actually serving the fx.php site.
Are you saying that I don't need it or that it is causing the problem?
I only know that you don't need since I have simple installation on my windows7, it has only anonymous authentication in IIS and show basic authentication dialogue when access to it with /fmi/xml/fmresultset.xml url using browser.
I hadn't test the IIS itself having basic authentication.
Did you check the active account using admin-console ?