|-----Original Message----- |From: jeffrey_n_Dyke@xxxxxxxxx [mailto:jeffrey_n_Dyke@xxxxxxxxx] |Sent: 12 May 2004 13:43 |To: Alex Gemmell |Cc: PHP List |Subject: Re: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
