[PHP-DB] Problem with PHP ODBC
Hi, I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my debian odbc tools and odbcinst. Under Linux i have an error in /var/log/apache/error.log Can't alloc filename Unable to locate database /var/www/foo.mdb I tried to relax permissions on my file foo.mdb (chmod 777) but i have the same error. Ideas ? Olivier FONTES Bad English speaking frenchie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with PHP ODBC
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob On Wed, 5 May 2004 [EMAIL PROTECTED] wrote: Hi, I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my debian odbc tools and odbcinst. Under Linux i have an error in /var/log/apache/error.log Can't alloc filename Unable to locate database /var/www/foo.mdb I tried to relax permissions on my file foo.mdb (chmod 777) but i have the same error. Ideas ? Olivier FONTES Bad English speaking frenchie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with PHP ODBC
I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my debian odbc tools and odbcinst. Under Linux i have an error in /var/log/apache/error.log Can't alloc filename Unable to locate database /var/www/foo.mdb I tried to relax permissions on my file foo.mdb (chmod 777) but i have the same error. Ideas ? Olivier FONTES Bad English speaking frenchie Selon Robert Twitty [EMAIL PROTECTED]: If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob My problem is i can't modify my PHP code. Actually the web site runs on a windows2000 workstation and odbc work fine, y want to port this website with minimal modifications on a linux machine. I don't have time to code another system to import my access database. Olivier FONTES -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with PHP ODBC
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob My problem is i can't modify my PHP code. Actually the web site runs on a windows2000 workstation and odbc work fine, y want to port this website with minimal modifications on a linux machine. I don't have time to code another system to import my access database. Then this may be difficult for you. Open source ODBC support for MS Access on Linux is only available with MDB Tools. Depending on what you are doing, it may not behave the same as the MS Access ODBC driver on Windows. If you were using a DB abstraction library like ADODb or PEAR DB, then porting would not be difficult. IF you cannot get MDB Tools to work, you may need to find a commercial MS Access ODBC driver that works on Linux. Take a look at http://bryanmills.net:8086/archives/99.html. It shows you how to configure MDB Tools and unixODBC to work with PHP. -- bob Olivier FONTES -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
