RE: [PHP-DB] ODBC with MS Access DB
| From: | Andrew Hill | Date: | Thu, 13 Dec 2001 21:42:45 +0000 |
| Subject: | RE: [PHP-DB] ODBC with MS Access DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15005@lists.php.net to get a copy of this message | ||
Charles,
The specific error message would be helpful.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Charles F. McKnight [mailto:cfm@mywebsitesucks.com]
> Sent: Thursday, December 13, 2001 4:21 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] ODBC with MS Access DB
>
>
> I am writing a simple application that will store data in an
> Access database.
> I have gotten a simple script that connects and selects some data from the
> database and this works fine. when I try to insert or update data
> it fails. I
> assume I am missing some permissions or something to make it be
> readonly when I connect but the following is the relevant code in case it
> lies there:
>
> $db=odbc_connect('test', 'test', 'test')
> $query="INSERT INTO test (firstname) VALUES('Charles')";
> $result=odbc_exec( $db, $query);
>
> As you can see it is about as simple as I can make it for a test so if
> someone could point me in the right direction to get this up and running I
> would greatly appreciate it.
>
> Thanks in advance,
> Charles
>
> --
> Charles F. McKnight IRC: sokudo | Doubt is not a pleasant
> condition, but
> cfm@myemailsucks.com ICQ: 2794793 | certainty is absurd.
> cfmck@usa.com PGP: 0x20A5BCE5 |
> - Voltaire
> --------------------[ http://chucksays.mywebsitesucks.com
> ]---------------------
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>