RE: [PHP-DB] Error insert into MS-access through ODBC not aviable
| From: | Andrew Hill | Date: | Wed, 13 Feb 2002 14:16:32 +0000 |
| Subject: | RE: [PHP-DB] Error insert into MS-access through ODBC not aviable | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16902@lists.php.net to get a copy of this message | ||
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:penockio@hotmail.com]
> Sent: Tuesday, February 12, 2002 12:51 PM
> To: php-db@lists.php.net
> 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
>
>
>