Re: Re: Cannot Insert into Paradox Tables...

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" <webmaster@globalmap.com> wrote in message news:5.1.0.14.0.20020710151551.00ac7dd0@pop.globalmap.com... > > >"Kondwani Spike Mkandawire" <kondwani@cs.mun.ca> wrote in message > >news:20020710173800.9174.qmail@pb1.pair.com... > > > 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 >