RE: [PHP-DB] ODBC with MS Access DB

2001-12-13 Thread Andrew Hill

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:[EMAIL PROTECTED]]
> Sent: Thursday, December 13, 2001 4:21 PM
> To: [EMAIL PROTECTED]
> 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
> [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]
>
>
>



-- 
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]




[PHP-DB] ODBC with MS Access DB

2001-12-13 Thread Charles F. McKnight

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
[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]