Does PHP5 support querying an MS Access MDE file?
in [Databases]
|
Prev: DB interface problem
Next: Doc to PDF with mssql
From: "Timothy Legg" on 2 Nov 2009 17:54 Hello, I have PHP Version 5.2.6-1+lenny3 I have been having difficulty using odbc_connect with an MS Access MDE database. I do have php5-mysql and php5-odbc installed on this server. Due to the rather poor search results regarding the topic of querying MDE files with PHP, I am becoming increasingly concerned that this file type is not supported. Is it possible to query an MDE file via PHP5 or should I try different approach to querying the database from our linux server? I am interested in your thoughts. Thanks for your help. Tim Legg
From: Richard Quadling on 3 Nov 2009 04:50 2009/11/2 Timothy Legg <php_list(a)timothylegg.com>: > Hello, > > I have PHP Version 5.2.6-1+lenny3 > > I have been having difficulty using odbc_connect with an MS Access MDE > database. Â I do have php5-mysql and php5-odbc installed on this server. > > Due to the rather poor search results regarding the topic of querying MDE > files with PHP, I am becoming increasingly concerned that this file type > is not supported. > > Is it possible to query an MDE file via PHP5 or should I try different > approach to querying the database from our linux server? Â I am interested > in your thoughts. > > Thanks for your help. > > Tim Legg > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > If you have the MS Access ODBC driver installed, then have you tried accessing the MDE as an MDB? -- ----- Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling
From: "Timothy Legg" on 3 Nov 2009 09:24 > 2009/11/2 Timothy Legg <php_list(a)timothylegg.com>: >> Hello, >> >> I have PHP Version 5.2.6-1+lenny3 >> >> I have been having difficulty using odbc_connect with an MS Access MDE >> database. � I do have php5-mysql and php5-odbc installed on this server. >> >> Due to the rather poor search results regarding the topic of querying >> MDE >> files with PHP, I am becoming increasingly concerned that this file type >> is not supported. >> >> Is it possible to query an MDE file via PHP5 or should I try different >> approach to querying the database from our linux server? � I am >> interested >> in your thoughts. >> >> Thanks for your help. >> >> Tim Legg >> > > If you have the MS Access ODBC driver installed, then have you tried > accessing the MDE as an MDB? > Yes, I have. The username and password are arbitrarily set since the management hasn't provided that data for me yet. But I am not far enough along to have run into a user rights issue. I get a warning and also an error upon interpreting the page. I have checked the path to the database file, and it is correct. I also checked file ownership and readability permissions, too. So maybe the name of the driver is wrong; it does look a little verbose to me, but it did come straight from the php.net online documentation. Error messages and source is below. Sorry, I modified the domain name in the path for privacy. Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/www.example.com/ht-secure/database_entry/test.php on line 9 <?php $mdbFilename = "/root/tims_db.mde"; $user = "root"; $password = "1248163264"; $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password); ?> Thanks for looking this over, Tim Legg > > > -- > ----- > Richard Quadling > "Standing on the shoulders of some very clever giants!" > EE : http://www.experts-exchange.com/M_248814.html > Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 > ZOPA : http://uk.zopa.com/member/RQuadling >
From: Richard Quadling on 3 Nov 2009 10:07 2009/11/3 Timothy Legg <php_list(a)timothylegg.com>: >> 2009/11/2 Timothy Legg <php_list(a)timothylegg.com>: >>> Hello, >>> >>> I have PHP Version 5.2.6-1+lenny3 >>> >>> I have been having difficulty using odbc_connect with an MS Access MDE >>> database. Ã I do have php5-mysql and php5-odbc installed on this server. >>> >>> Due to the rather poor search results regarding the topic of querying >>> MDE >>> files with PHP, I am becoming increasingly concerned that this file type >>> is not supported. >>> >>> Is it possible to query an MDE file via PHP5 or should I try different >>> approach to querying the database from our linux server? Ã I am >>> interested >>> in your thoughts. >>> >>> Thanks for your help. >>> >>> Tim Legg >>> >> >> If you have the MS Access ODBC driver installed, then have you tried >> accessing the MDE as an MDB? >> > > Yes, I have. Â The username and password are arbitrarily set since the > management hasn't provided that data for me yet. Â But I am not far enough > along to have run into a user rights issue. Â I get a warning and also an > error upon interpreting the page. Â I have checked the path to the database > file, and it is correct. Â I also checked file ownership and readability > permissions, too. Â So maybe the name of the driver is wrong; it does look > a little verbose to me, but it did come straight from the php.net online > documentation. > > Error messages and source is below. Â Sorry, I modified the domain name in > the path for privacy. > > Warning: odbc_connect() [function.odbc-connect]: SQL error: > [unixODBC][Driver Manager]Data source name not found, and no default > driver specified, SQL state IM002 in SQLConnect in > /var/www/www.example.com/ht-secure/database_entry/test.php on line 9 > > > <?php > $mdbFilename = "/root/tims_db.mde"; > $user = "root"; > $password = "1248163264"; > > $connection = odbc_connect("Driver={Microsoft Access Driver > (*.mdb)};Dbq=$mdbFilename", $user, $password); > > ?> > > Thanks for looking this over, > > Tim Legg > >> >> >> -- >> ----- >> Richard Quadling >> "Standing on the shoulders of some very clever giants!" >> EE : http://www.experts-exchange.com/M_248814.html >> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 >> ZOPA : http://uk.zopa.com/member/RQuadling >> > > > You've got odbc, but probably not a driver for MS Access. You need both. I can't seem to find a unix driver for MSAccess. Converting to a different DB would help (mysql, sqlite). -- ----- Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling
From: Niel Archer on 3 Nov 2009 14:44
> 2009/11/3 Timothy Legg <php_list(a)timothylegg.com>: > >> 2009/11/2 Timothy Legg <php_list(a)timothylegg.com>: > >>> Hello, > >>> > >>> I have PHP Version 5.2.6-1+lenny3 > >>> > >>> I have been having difficulty using odbc_connect with an MS Access MDE > >>> database. Â I do have php5-mysql and php5-odbc installed on this server. > >>> > >>> Due to the rather poor search results regarding the topic of querying > >>> MDE > >>> files with PHP, I am becoming increasingly concerned that this file type > >>> is not supported. > >>> > >>> Is it possible to query an MDE file via PHP5 or should I try different > >>> approach to querying the database from our linux server? Â I am > >>> interested > >>> in your thoughts. > >>> > >>> Thanks for your help. > >>> > >>> Tim Legg > >>> > >> > >> If you have the MS Access ODBC driver installed, then have you tried > >> accessing the MDE as an MDB? > >> > > > > Yes, I have. The username and password are arbitrarily set since the > > management hasn't provided that data for me yet. But I am not far enough > > along to have run into a user rights issue. I get a warning and also an > > error upon interpreting the page. I have checked the path to the database > > file, and it is correct. I also checked file ownership and readability > > permissions, too. So maybe the name of the driver is wrong; it does look > > a little verbose to me, but it did come straight from the php.net online > > documentation. > > > > Error messages and source is below. Sorry, I modified the domain name in > > the path for privacy. > > > > Warning: odbc_connect() [function.odbc-connect]: SQL error: > > [unixODBC][Driver Manager]Data source name not found, and no default > > driver specified, SQL state IM002 in SQLConnect in > > /var/www/www.example.com/ht-secure/database_entry/test.php on line 9 > > > > > > <?php > > $mdbFilename = "/root/tims_db.mde"; > > $user = "root"; > > $password = "1248163264"; > > > > $connection = odbc_connect("Driver={Microsoft Access Driver > > (*.mdb)};Dbq=$mdbFilename", $user, $password); > > > > ?> > > > > Thanks for looking this over, > > > > Tim Legg > > > >> > >> > >> -- > >> ----- > >> Richard Quadling > >> "Standing on the shoulders of some very clever giants!" > >> EE : http://www.experts-exchange.com/M_248814.html > >> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 > >> ZOPA : http://uk.zopa.com/member/RQuadling > >> > > > > > > > > You've got odbc, but probably not a driver for MS Access. > > You need both. > > I can't seem to find a unix driver for MSAccess. > > Converting to a different DB would help (mysql, sqlite). I had a similar problem. I had to access (pardon the pun) a very old MS Access db. Being on x64 windows ODBC is not an option, so in the end I used OpenOffice.org with a java driver to open it and copy data to MySQL. > -- > ----- > Richard Quadling > "Standing on the shoulders of some very clever giants!" > EE : http://www.experts-exchange.com/M_248814.html > Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 > ZOPA : http://uk.zopa.com/member/RQuadling > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- Niel Archer niel.archer (at) blueyonder.co.uk |