|
|
Posted by Richard Quick on 05/27/05 09:14
"Adam" <anon@nowhere.com> wrote in message
news:mlpb91h30oo76qqqplrn6ocb47b1ean4bh@4ax.com...
> On Wed, 25 May 2005 15:49:45 +0100, Richard Quick wrote:
>
> >Have a look on Google for:
> >
> >PHP Access DSNless connection
> >
> >You don't need to use an ODBC connection to an access database (provided
the
> >server is Windows-based).
>
> I found DSN-less connections to Access databases in PHP pretty flakey.
> I couldn't seem to create/use more than one call per page/script with
> any degree of stabilty. One per page was fine. Never really found out
> what I was doing wrong.
I've never really had that problem - though I did find access to be pretty
slow.
> >Using a DSNless connection you can just upload a standard .mdb file and
> >access the data in the file.
> >
> >You use SQL just the same as you would with any other database (albeit
MS's
> >somewhat limited Jet SQL). The only difference is in the initial
> >connection.
> >
> >Big down side is that if someone guesses there is an access file there
they
> >could download it by typing the correct address into their browser. So
> >never call your database bd1.mbd!
>
> Can't you put the d/b outside webspace? Even with ColdFusion on
> Windows, I *never* put databases in public webspace.
You can, yes, but it depends on the level of access (no pun intended) you
have to the server. If you've just got paid-for virtual hosting you may not
be able to do this. What you *can* do is give the database an unguessable
name and then password protect it.
--
Richard Quick
http://www.chocolatemagazine.co.uk
Navigation:
[Reply to this message]
|