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

Reply via email to