Thanks Peter,

A very kind offer, but I'm tied to my hosts and to using MS Access.  I have
been using PHP throughout the website but could possibly use ASP for this
very small part of the site (i.e. display a record of 20 fields depending on
who logins in).  I need to learn ASP however and I don't have much time so I
was hoping to avoid it.


Alex
|:| Reply-to: [EMAIL PROTECTED] |:|
 
|-----Original Message-----
|From: Peter Lovatt [mailto:[EMAIL PROTECTED]
|Sent: 12 May 2004 15:03
|To: Alex Gemmell
|Subject: RE: [PHP-DB] Linux/PHP/Access Database - oh boy :(
|
|Hi
|
|Are you tied to the database(could you just export it to MySql?)
|Are you tied to the hosting provider?
|Are you tied to php?
|
|We might be able to add the tools to a Linux server or sort you out with a
|php enabled windows server if you don't mind covering some admin time.
|
|
|Peter
|
|
|-----------------------------------------------
|Excellence in internet and open source software
|-----------------------------------------------
|Sunmaia
|Birmingham
|UK
|www.sunmaia.net
|tel : 0121-242-1473
|fax : 0870 7621758
|International +44-121-242-1473
|-----------------------------------------------
|
|
|
|
|
|> -----Original Message-----
|> From: Robert Twitty [mailto:[EMAIL PROTECTED]
|> 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
|>
|> --
|> 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

Reply via email to