Hi All,
Currently, I am exploring the ODBC connection (MS Access) with PHP. I executed the below PHP script.
$Username = "admin";
$SessionID = "Ux99ulB5p8PnMJWl3ZBs";
$Query1 = "INSERT INTO login ".
"(Username, SessionID) ".
"VALUES ('$Username', '$SessionID')";
$result1 = odbc_do($cn, $Query1);
However, it thrown out the below error message.
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect.
May I know whether my script is incorrect? Please help.
Thanks in advance.
Regards,
Desmond.
PHP with ODBC Connection (MS Access)
Moderator: General Moderators