Jump to content

Help!! I cannot INSERT INTO queries with odbc_exec


gaorellana
 Share

Recommended Posts

I am newbie with php, and I am using Win XP and IIS and my web server is in the localhost.

about read only attribute I did check on MS Access File>DataBase Properties in the General tab and the Attributes group is disabled (light grayed) but I acn see the check read only unchecked.

Also if I check the attributes outside from Access i.e. Windows Explorer the attribute flag readonly in unchecked too.

I post a check list of what I did.

1.create a MS Access Database (blank database) from the MS Access task pane.

2.locate the database outside the root path of the web folder.
My root path for web is c:\inetpub\wwwroot\mysite and the folder for the db is in c:\inetpub\wwwroot\mysite_db

3.I created a SystemDSN and give it the user and admin in advanced options of the ODBC Manager.

4.Wrote this code:

[code]$val = array();
$con=odbc_connect("mySystemDSN","Admin","a_password");
$sql="exec user_A 'pepe', 'pepe','123456','pepe@pipo.pp','127.0.0.1','123456',0";
$rs = odbc_exec($con, $sql);
odbc_free_result ( $rs );
odbc_close( $con );[/code]

First I used to login with blank admin and pwd. Then I attached the account Admin of the Access database a paswword. I still get the same ODBC error:

[color=green]Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect [/color]

I still didn't get an idea of what is going on.
thanks in advance
Link to comment
Share on other sites

[url=http://www.phpbb.com/phpBB/viewtopic.php?t=66572.]http://www.phpbb.com/phpBB/viewtopic.php?t=66572.[/url]

[url=http://www.zend.com/zend/tut/odbc.php?article=odbc&kind=t&id=3015&open=1&anc=0&view=1]http://www.zend.com/zend/tut/odbc.php?article=odbc&kind=t&id=3015&open=1&anc=0&view=1[/url]

Something about IUSR in XP i think.
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.