Penockio, You might find this helpful: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -----Original Message----- > From: Penockio [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 12:51 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Error insert into MS-access through ODBC not aviable > > > 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 > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php