RE: [PHP-DB] Linux/PHP/Access Database - oh boy :(
| From: | Alex Gemmell | Date: | Wed, 12 May 2004 14:30:55 +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-34386@lists.php.net to get a copy of this message | ||
Thanks Bob,
I was afraid of that! Ah well. I have one or two more glimmers of hope
left before I abandon this entirely and learn some ASP super-quickly!
Alex
|:| Reply-to: alex.gemmell@virgin.net |:|
|-----Original Message-----
|From: Robert Twitty [mailto:rtwitty@neutron.ushmm.org]
|Sent: 12 May 2004 14:54
|To: Alex Gemmell
|Cc: PHP List
|Subject: Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(
|
|On Wed, 12 May 2004, Alex Gemmell wrote:
|
|> Hello all,
|>
|> I am fairly new to Linux/PHP so please bear with me. I have an awfully
|> awkward problem to solve - a stop gap solution for the next 6 months
|until
|> we have out in-house servers set up and running. I also have a very
|short
|> timeframe to sort this out. I am using PHP on a remotely hosted Linux
|web
|> server to build my website, however I have been given a MS Access
|database
|> to use! Despite my best efforts (and two days Google trawling) I haven't
|> found a suitable solution so I am turning to your collective knowledge.
|>
|> First things first - I do not run the server and cannot install any new
|> tools on to it (I cannot access the folders above my web root). There
|are
|> lots of suggestions on the net about installing MDBTools and UnixODBC RPM
|> (http://bryanmills.net:8086/archives/000099.html) - but that involves the
|> admin who won't do it! I can, of course, put scripts that may help in
|the
|> actual web folder and reference them if anyone has any ideas.
|>
|> I know I must use a DSN-less connection. I first tried connecting
|directly
|> to the mdb file using:
|> $conn = new COM("ADODB.Connection") or die ("Cannot create
|ADODB
|> Connection object.");
|
|You cannot do this on Linux because I don't believe it supports COM nor
|OLEDB. If your ISP allows you to use dynamically loadable PHP extensions,
|then you might be able to use ODBTP. But, this solution requires the use
|of a Windows machine that can be accessed by the Linux box via port 2799,
|which may not be possible for you. Thus, your only option would be
|MDBTools and unixODBC.
|
|If your provider won't let you install MDBTools or ODBTP, then your only
|solution is to get a new provider.
|
|-- bob