Error insert into MS-access through ODBC not aviable

From: Date: Tue, 12 Feb 2002 17:51:02 +0000
Subject: Error insert into MS-access through ODBC not aviable
Groups: php.db 
Request: Send a blank email to php-db+get-16894@lists.php.net to get a copy of this message
I can't use sql command "insert into " but I can use "select" and it condition.I use DSN that provide by ODBC and use MS-Access as source file. my code : $connect = odbc_connect("sosdb","","") or die ("can not connect") ; ->successfult $order_trans_detail_sql = "insert into order_trans_detail (order_id,cus_id,order_place) values ('02120200007','0071577722451188','548/12 123 Road Patumwan') ; " ; $exec = odbc_exec($connect,$order_trans_detail_sql ) or die ("cannot insert order trans detail<br>") ; -> warning as below all field is text field for database MS-Access .and I connect it through ODBC by ms access driver use (DSN) I found Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in

« previous php.db (#16894) next »