ODBC_exec on IIS

Anon

Has anyone experienced the problem of not being able to run UPDATE, DELETE, INSERT odbc queries for Access97 databases on pages that are not protected by IIS Challenge/Response or Basic Authentication security?

SELECT statements work fine, it's just when trying to change the database I get errors like:

PHP 3 Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query., SQL state S1000 in SQLExecDirect in D:\InetPub\other\test.php on line 8

Thanks, Ryan

Anon

did you ever get and answer to this problem? I am having the exact same problem.... but I do have challenge/response set up on my site.

Ryan wrote:

SELECT statements work fine, it's just when trying to change the database I get errors like:

PHP 3 Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query., SQL state S1000 in SQLExecDirect in D:\InetPub\other\test.php on line 8

Thanks, Ryan

Anon

Yes I did. When using this security setup, you need to specify which user profile their access is determined by. THe default user is not very powerful, so you need to set it youself. This will give the user the power to modify the database.

Anon

Thanks,

I made the security changes, and then found all of it working great. I often have trouble finding anyone working with php in an IIS enviroment, and so problems like this become very trial and error oriented. I myself have always used PHP in the Linux Apache/Mysql enviroment, so I have a good grasp of PHP, but sometimes miss the smaller NT/IIS/Access details.

Again thanks for all the help... You probably saved me three days of trying to figure out what was wrong with my query.

Lee Lemon

Anon

What security setup to get this to work ?

Win2000, IIS5, Access - ODBC, PHP4

Anon

In IIS, you can set the security permissions for unauthorized users. Set this to something more powerful than the default user (like admin). I forget what screen this is done in, but it must be in the documentation.

The unauthorized user must have enough security permissions to perform changes (UPDATE, INSERT, etc) on the database.

Anon

I've done this in Win2K with no problem, I've now switched to WinXP Pro and i can't find the Secuirty Tab to allow access. Anyone know how to get around this.