Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
Hi people,
I need to be able to connect to an Access database that is on a web server using PHP and cant get it to work. The error message im getting says its trying to use an non-object (or something along those lines). can anyone help me out a little?
Also the server has PHP 4.4, should i update this, and how is it done.
Thanks guys 
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
for an accesss database you will need to create an ODBC datasource and give it a name, have you not considered using SQL? far better
|
Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
I have thought about it but wasnt sure how to go about it - i have never set the server side of things up before (this is my uni placement year)
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
its probably easier to setup than an access db, just install mysql and create a new instance in it, its quite straightforward and all GUI based
download mysql and have a play
|
Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
ok thanks 
How easy/difficult would it be to set my home machine up to run PHP/mysql? - would it need to be a web server or could i simply run the files locally just for testing purposes
[Edited on 09-09-2006 by Planty02]
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
you will need apache, php, or which is probably easier is an all in solution like xampp
|
Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
ok thanks - ill have a crack at it today
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
I've got a home development machine at home here. Currently running Apache 1.3.35 with PHP 5.1 and MySQL Server 5.0.
It took me a while to set it up but follow the installation instructions you should be fine.
See http://www.php.net, http://www.apache.org and http://www.mysql.com for the latest downloads
edit - fixed link
[Edited on 09-09-2006 by aPk]
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
just download xampp it has apache php and mysql all inbuilt in the package, it sets it up all for you
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
I saw that but decided to go for the challenge of installing everything seperately - is much easier to use an all in one installer as above - I'd recommend Steve's link over mine unless you'd like a bit of a challenge!
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
yes if its only for testing then all in one is fine, if your doing full on hosting, better to install all the bits seperatly to allow full customisation
|
Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
ive got an all in one set up on my home machine but i think ill try install them seperately at work as it will be for full on hosting of a web application
thanks for all the help guys
|
drax
Member
Registered: 5th Feb 05
Location: Sittingbourne, Kent
User status: Offline
|
get WAMP its very cool stuff 
|
Planty02
Member
Registered: 5th Mar 05
Location: Burslem, Stoke-on-Trent
User status: Offline
|
Cheers for all the help guys
Will give a few things a try tommorow at work, main prioroty is to get a mysql database up and password protected
|
