[PHP-DB] Re: Accessing Foxpro free tables using ODBC
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 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 PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Looks like a file permissions problem perhaps. Grant access to the the IIS user or make the file public to everyone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Accessing Foxpro free tables using ODBC
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 for helping. John Lim [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Accessing Foxpro free tables using ODBC
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 be accessed from other programs, is it possible that I have left out something when configuring PHP? Hi Looks like a file permissions problem perhaps. Grant access to the the IIS user or make the file public to everyone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Accessing Foxpro free tables using ODBC
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 PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Looks like a file permissions problem perhaps. Grant access to the the IIS user or make the file public to everyone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php