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 F. McKnight   IRC: sokudo      | Doubt is not a pleasant condition, but
[EMAIL PROTECTED]  ICQ: 2794793     | certainty is absurd.
[EMAIL PROTECTED]         PGP: 0x20A5BCE5  |                         - Voltaire
--------------------[ http://chucksays.mywebsitesucks.com ]---------------------

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to