FrontBase insert query

[di98saar]

I'm having a problem using INSERT SQL-statements with PHP on IIS6.

INSERT statement don't work but SELECT's do.
When I run the exact same SQL statement using the SQL client directly to the database, it works like a charm.

This is the code:
$open = fbsql_connect("localhost", "Tore");
$sql="INSERT INTO leverantor (leverantorsnr,leverantorsnamn) VALUES (418,'Edstroms AB');";
$data = fbsql_db_query("Tore",$sql);

Any help would be greatly appreciated.

/Aron

[Roger_Ramjet]

This is to do with the IIS and/or NTFS security privileges on the web site and db. Anonymouse web user IUSR_host by default has only read access, so you can query the data but not update it. You need to change the access privileges to allow write as well for the anon client.

[di98saar]

I tried changing the IUSR user to have more priviliges but to no avail.

It still turned out to be a user problem, however. I was using the wrong account in the fbsql_connect statement. I tried with the same as the sql client uses and that worked.

Thanks for your help. You led me in the right direction with user issues.

/Aron