ani_nabo
-
Posts
1 -
Joined
-
Last visited
Never
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.
PHP, MS Access, ODBC: Insert query error
in PHP Coding Help
Posted
I am getting the following error when I am trying to do an insert query when I am using PHP with Access database connected with an ODBC connection:
CODE:
$db= odbc_connect("Access","","");
$query1 = "INSERT INTO TestTable ([LastName]) VALUES ('$LastName')";
$result1=odbc_exec($db,$query1);
ERROR:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect
I also tried the following but with no luck:
CODE:
$query1 = "INSERT INTO WebDiamondDUser([LastName]) VALUES (\'$LastName\')";
ERROR:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '\'Blackham\''., SQL state 37000 in SQLExecDirect
CODE:
$query1 = "INSERT INTO WebDiamondDUser([LastName]) VALUES ($LastName)";
ERROR:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect
Any suggestion???????