[Phpwm] RE: Accessing an MS Access DB remotely. (Chris Allen)

Tue Oct 17 13:17:06 BST 2006

I have took a look and I agree it will potentially be shaky using access, 
however are you implying that without writing something to 'expose' the 
Access DB, it cannot be done?

I thought it was possible to set up an ODBC DSN on the DB machine, and talk 
to the db using PHP ADOdb, as this has libraries for Ms Access.

Would someone be able to confirm if this is possible? When I say possible, I 
do not mean 'robust' or 'reliable', but simply possible. I personally am not 
keen on this idea in practice, but as it has already been quoted for ( yes, 
really, but not by myself ) my hands are tied :)

Thanks folks

>From: phpwm-request at mailman.lug.org.uk
>Reply-To: phpwm at mailman.lug.org.uk
>To: phpwm at mailman.lug.org.uk
>Subject: Phpwm Digest, Vol 39, Issue 3
>Date: Tue, 17 Oct 2006 12:15:25 +0100
>
>Send Phpwm mailing list submissions to
>	phpwm at mailman.lug.org.uk
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://mailman.lug.org.uk/mailman/listinfo/phpwm
>or, via email, send a message with subject or body 'help' to
>	phpwm-request at mailman.lug.org.uk
>
>You can reach the person managing the list at
>	phpwm-owner at mailman.lug.org.uk
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Phpwm digest..."
>
>
>Today's Topics:
>
>    1. RE: Accessing an MS Access DB remotely. (Dave Holmes)
>    2. Re: Accessing an MS Access DB remotely. (Rob Allen)
>    3. Re: installing ZIP functions (Stephen Parkes)
>    4. RE: installing ZIP functions (Darren Beale)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Tue, 17 Oct 2006 07:53:22 +0100
>From: "Dave Holmes" <Dave at neteffekt.co.uk>
>Subject: RE: [Phpwm] Accessing an MS Access DB remotely.
>To: "'West Midlands PHP User Group'" <phpwm at mailman.lug.org.uk>
>Message-ID: <E1GZipN-00066y-00 at xinit.lug.org.uk>
>Content-Type: text/plain;	charset="us-ascii"
>
>I think I will diplomatically refrain from this conversation!
>
>Sorry couldn't resist....
>
><programmers_hat>
>
>but I think it has all been said in the previous emails access is a poor
>choice for any application office based or other and has never worked well
>on the Internet.
>
>You could write a web service which exposes it but I would recommend 
>getting
>the web service to drop the requests in a queue and then a processor
>application to process then in a serial manner to avoid any multi-user
>issues.
>
>If this is an order processing system i.e. business critical then you can't
>risk the very real potential for data corruption & loss.
>
></programmers_hat>
>
>
><entrepreneurs_hat>
>
>Surely there is an opportunity here for you to sell the a holistic web /
>intranet based system which fully meets their strategic requirements?
>
>Or are they the type of client that wants to world for 50p and a bag of 
>pork
>scratchings!
>
></entrepreneurs_hat>
>
>
>
>-----Original Message-----
>From: phpwm-bounces at mailman.lug.org.uk
>[mailto:phpwm-bounces at mailman.lug.org.uk] On Behalf Of Chris Allen
>Sent: 16 October 2006 10:19
>To: phpwm at mailman.lug.org.uk
>Subject: [Phpwm] Accessing an MS Access DB remotely.
>
>I was wondering if anyone would be able to offer any pointers on this
>matter:
>
>A client has an internal system at his office, that is based on Microsoft
>Access 2002. This is used as a customer database, order processing etc.
>
>He wants an online portal to this database, whereby Engineers with PDA's 
>can
>view outstanding jobs assigned to them, and interact in real time with the
>internal system.
>
>I have done something similar using PDA's with PHP in the past, but it
>involved an onsite webserver and middleware, in order to protect the
>internal database.
>
>This is what I want: The web portal will be hosted elsewhere, and the 
>access
>DB will remain on the customers site. Is there a way of accessing this
>database from the outside world via PHP and performing SQL queries on it? I
>assume it will need some sort of server setting up onsite?
>
>Thanks.
>
>
> >From: phpwm-request at mailman.lug.org.uk
> >Reply-To: phpwm at mailman.lug.org.uk
> >To: phpwm at mailman.lug.org.uk
> >Subject: Phpwm Digest, Vol 38, Issue 6
> >Date: Sat, 14 Oct 2006 12:15:16 +0100
> >
> >Send Phpwm mailing list submissions to
> >	phpwm at mailman.lug.org.uk
> >
> >To subscribe or unsubscribe via the World Wide Web, visit
> >	https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >or, via email, send a message with subject or body 'help' to
> >	phpwm-request at mailman.lug.org.uk
> >
> >You can reach the person managing the list at
> >	phpwm-owner at mailman.lug.org.uk
> >
> >When replying, please edit your Subject line so it is more specific
> >than "Re: Contents of Phpwm digest..."
> >
> >
> >Today's Topics:
> >
> >    1. RE: IRC (James Blizzard)
> >    2. RE: IRC (James Blizzard)
> >
> >
> >----------------------------------------------------------------------
> >
> >Message: 1
> >Date: Fri, 13 Oct 2006 18:06:37 +0100
> >From: "James Blizzard" <jim at acidhl.co.uk>
> >Subject: RE: [Phpwm] IRC
> >To: <public.darren.beale at siftware.co.uk>,	"'West Midlands PHP User
> >	Group'" <phpwm at mailman.lug.org.uk>
> >Message-ID: <002301c6eee9$f5e7aef0$0200a8c0 at jim>
> >Content-Type: text/plain;	charset="us-ascii"
> >
> > >> #phpwm
> > >> on:irc.freenode.net
> >
> > >must.resist
> >
> >
> >--
> >Darren Beale
> >
> >Siftware
> >1 North Works
> >London Lane
> >Upton-upon-Severn
> >WR8 0HH
> >
> >t: 01684 59 49 59
> >m: 07711 716 197
> >
> >w: http://siftware.co.uk
> >
> >--
> >No virus found in this outgoing message.
> >Checked by AVG Free Edition.
> >Version: 7.1.408 / Virus Database: 268.13.3/473 - Release Date:
> >12/10/2006
> >
> >
> >
> >_______________________________________________
> >Phpwm mailing list
> >Phpwm at mailman.lug.org.uk
> >https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >
> >
> >
> >
> >
> >
> >
> >------------------------------
> >
> >Message: 2
> >Date: Fri, 13 Oct 2006 18:07:15 +0100
> >From: "James Blizzard" <jim at acidhl.co.uk>
> >Subject: RE: [Phpwm] IRC
> >To: <public.darren.beale at siftware.co.uk>,	"'West Midlands PHP User
> >	Group'" <phpwm at mailman.lug.org.uk>
> >Message-ID: <002601c6eeea$0c54cd80$0200a8c0 at jim>
> >Content-Type: text/plain;	charset="us-ascii"
> >
> > >> #phpwm
> > >> on:irc.freenode.net
> >
> > >must.resist
> >
> >I keep trying to get out, but they keep drawing me back in!
> >
> >
> >
> >
> >
> >------------------------------
> >
> >_______________________________________________
> >Phpwm mailing list
> >Phpwm at mailman.lug.org.uk
> >https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >
> >
> >End of Phpwm Digest, Vol 38, Issue 6
> >************************************
>
>_________________________________________________________________
>Be the first to hear what's new at MSN - sign up to our free newsletters!
>http://www.msn.co.uk/newsletters
>
>
>_______________________________________________
>Phpwm mailing list
>Phpwm at mailman.lug.org.uk
>https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
>
>
>------------------------------
>
>Message: 2
>Date: Tue, 17 Oct 2006 08:22:30 +0100
>From: Rob Allen <rob at akrabat.com>
>Subject: Re: [Phpwm] Accessing an MS Access DB remotely.
>To: West Midlands PHP User Group <phpwm at mailman.lug.org.uk>
>Message-ID: <453484B6.3080106 at akrabat.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>Dave Holmes wrote:
>
> >
> > Or are they the type of client that wants to world for 50p and a bag of 
>pork
> > scratchings!
> >
>
>Aren't they all?!
>
>
>Personally, I'd write an app to expose the Access database as a service
>and then talk to the service. Then I'd replace Access with something
>else when it falls over...
>
>Regards,
>
>Rob...
>
>
>
>------------------------------
>
>Message: 3
>Date: Tue, 17 Oct 2006 08:27:01 +0100
>From: "Stephen Parkes" <sparkes at westmids.biz>
>Subject: Re: [Phpwm] installing ZIP functions
>To: "West Midlands PHP User Group" <phpwm at mailman.lug.org.uk>
>Message-ID:
>	<428c6c120610170027l2846e240o65d1b38d4a541e61 at mail.gmail.com>
>Content-Type: text/plain; charset="utf-8"
>
>On 10/17/06, Dave Holmes <Dave at neteffekt.co.uk> wrote:
> >
> > If you think laterally there are a number of ways to do this, obviously
> > the
> > first is to use the ZIP functions within PHP which do need to be 
>compiled
> > in.
>
>
>
>are my messages getting through?  because I gave the answer asked for first
>reply?
>
>
>
>
>--
>Steve 'sparkes' Parkes - tshirts http://nerd.ws - code http://zx-81.com
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: 
>http://mailman.lug.org.uk/pipermail/phpwm/attachments/20061017/48a1516f/attachment-0001.html
>
>------------------------------
>
>Message: 4
>Date: Tue, 17 Oct 2006 10:39:00 +0100
>From: "Darren Beale" <public.darren.beale at siftware.co.uk>
>Subject: RE: [Phpwm] installing ZIP functions
>To: "'West Midlands PHP User Group'" <phpwm at mailman.lug.org.uk>
>Message-ID: <001e01c6f1d0$171bfe80$c802a8c0 at Thinkpad>
>Content-Type: text/plain;	charset="windows-1250"
>
> > A word of advice would be take the time to learn how to
> > compile PHP and it's
> > associated extensions otherwise you will always be at the mercy of a
> > packager or distro. It's not that complicated to be honest.
>
>+1
>
>Whilst I would say that for most server software using maintained packages
>is A Good Thing because of the ease of upgrading (read: security patches)
>however I always run with a self compiled PHP and MySQL for the flexibility
>that it gives me.
>
>Get yourself a copy of the free VMWare server, do a server install that
>approximately mirrors your production environment and then play around with
>it until you're confident you know how to compile. It really isn't that 
>hard
>and remember that as long as you're only getting compile errors then you're
>not 'breaking' anything as you've not actually installed it yet.
>
>If it helps, some time ago I created a for-my-own-benefit mini how-to on
>creating a dev server. It's debian-centric but might help you out in a few
>places:
>http://bealers.com/how-to/creating-a-php-development-server/
>
>D
>
>--
>Darren Beale
>
>Siftware
>1 North Works
>London Lane
>Upton-upon-Severn
>WR8 0HH
>
>t: 01684 59 49 59
>m: 07711 716 197
>
>w: http://siftware.co.uk
>
>--
>No virus found in this outgoing message.
>Checked by AVG Free Edition.
>Version: 7.1.408 / Virus Database: 268.13.4/477 - Release Date: 16/10/2006
>
>
>
>
>
>------------------------------
>
>_______________________________________________
>Phpwm mailing list
>Phpwm at mailman.lug.org.uk
>https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
>End of Phpwm Digest, Vol 39, Issue 3
>************************************

_________________________________________________________________
The new Windows Live Toolbar helps you guard against viruses 
http://toolbar.live.com/?mkt=en-gb