Re: [PHP] Re: Cannot Insert into Paradox Tables...

2002-07-10 Thread Kondwani Spike Mkandawire

I am using Database Desk Top to create the tables...
I am a first timer to Databases, please tell me how
I can set these permissions...  I am working under
WinNT...  (I have not done much on any MS platforms
coz I have been using UNIX for the past 3 years...)...
I would be using chmod and tripple 6's to acquire
this under UNIX but I have no idea on how to go
about this under WinNT...
"Alex Piaz" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> >"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




Re: [PHP] Re: Cannot Insert into Paradox Tables...

2002-07-10 Thread Alex Piaz


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