>"Kondwani Spike Mkandawire" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am trying to insert info. into a paradox table but receive the following
> > message after inputting the data into the approriate fields...
> >
> > Warning: SQL error: [Microsoft][ODBC Paradox Driver] Operation
> > must use an updateable query., SQL state S1000 in SQLExecDirect
> > in c:\program files\apache group\apache\htdocs\coopstudent.php
> > on line 47
Your problem should be about file permissions. Try to give full permissions
to the IIS_USR for the Paradox tabel you want to extract data from.
Let me know if you have any other questions
Regards
Alex
> > I am able to retrieve info. from the table but when I write some Insertion
> > Code I receive the above message...
> >
> > This is what the code looks like... Please help...
> >
> > $db = odbc_connect("MyDNS", "who", "null");
> > $dreq = "INSERT INTO myTablet.db (field1, field2, field3...) VALUES
> > ('$field1', '$field2', '$field3'...)";
> > odbc_exec($db, $dreq);
> >
> > Thanks in advance...
> >
> > Kondwani
> >
> >
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
