Jump to content

ani_nabo

Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by ani_nabo

  1. Hello,

    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???????
×
×
  • 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.