[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-30 Thread John Lim
Hi Yue Teng, Right click on the directory in Explorer and change the NTFS permissions as appropriate. If you are not sure, set it to read/write Everyone. Best of luck-lah! John Yue Teng [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi John, It could be a

[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-30 Thread Yue Teng
Hi John, Finally got it to work. Guess what - my .dbf files were copied from an encrypted folder and so the .dbf files remained encrypted. Decrypted the files and now the script runs fine. Now it makes sense - whoever access the web shouldn't have access to encrypted files! Thanks a million

[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-29 Thread John Lim
Yue Teng [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear All, Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file c:\web\data\dblist.dbf., SQL state S1000 in SQLExecDirect in c:\web\test.php on line 10 Since the same ODBC DSN can

[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-29 Thread Yue Teng
Hi John, It could be a file permissions issue. I ran the script using PHP from XP's command prompt window and the output is fine. The problem occurs only when test.php is served by Apache. How should I grant the permissions? Do I modify php.ini or Apache's httpd.conf file? John Lim [EMAIL