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: alex.gemmell@xxxxxxxxxx |:| |-----Original Message----- |From: Peter Lovatt [mailto:pjln1@xxxxxxxxxxx] |Sent: 12 May 2004 15:03 |To: Alex Gemmell |Subject: RE: 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:rtwitty@xxxxxxxxxxxxxxxxx] |> Sent: 12 May 2004 14:54 |> To: Alex Gemmell |> Cc: PHP List |> Subject: Re: 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
