RE: [PHP-DB] Linux/PHP/Access Database - oh boy :(
| From: | Alex Gemmell | Date: | Wed, 12 May 2004 13:37:43 +0000 |
| Subject: | RE: [PHP-DB] Linux/PHP/Access Database - oh boy :( | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34381@lists.php.net to get a copy of this message | ||
|-----Original Message-----
|From: jeffrey_n_Dyke@Keane.com [mailto:jeffrey_n_Dyke@Keane.com]
|Sent: 12 May 2004 13:43
|To: Alex Gemmell
|Cc: PHP List
|Subject: Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(
|
|
|>Hello all,
|
|>Am I right in thinking I have very few options? I don't want to move
|over to ASP (would that even help?) because it means learning VBScript and
|I don't have a >lot of time. Also, I can't use another database (e.g.
|MySQL) cos the server admin is NOT helping me and won't install anything
|new.
|
|ok. I have not entirely thought this through, but if you're running a
|linux machine and can install stuff in your web space, then potentially you
|have another option. But _only_ if PHP is already compiled with mysql
|support. Couldn't you grab a mysql binary from mysql.com(that matches your
|client version compiled into PHP), and install it in your web space? And
|then use your linux user as the mysql user, and assign appropriate
|permissions to the directory per the INSTALL-BINARY document in the
|distrobution. or, even better, if you know the name of your web user
|(apache user)..you could also start it as that user, removing the security
|hole of using yours (which i'm sure has elevated rights).
|
|And I didn't think you could run COM on anything but a Widoze PHP build?
|adn you're on Linux?
|
|anyway... just an idea and maybe not a good one. But looks like you're
|stuck. There are potential issues, but .... well, again..just an idea.
|
|HTH....Good Luck!
|
|Jeff
Thank you Jeff! I will try to install the MySQL binary. Bit scary for me
(I'm a Microsoft-baby, we only PLAY at being good at this stuff ;) )...
Let me simplify my question so perhaps more people can offer an answer:
Does anyone know if it is possible to set up a DSN-less ODBC connection to a
Microsoft Access or dbase database file from a PHP page running on
Linux/Apache?
If it is possible can anyone provide an example (or a URL to one)? The
connection string is of particular interest to me! What "Driver" do I use
for connecting to a dbase database (exported from the MS Access database!).
Thanks again.
Alex