Install probs / using an Access database

Install probs / using an Access database

by Kieran Foley -
Number of replies: 2
Hi Everyone!

Want to run Moodle on a hosting companies Linux box, Apache as a Virtual Server

I am trying to install via Terrapin FTP from my home machine which is a Win2K SP2 box with IE 6 / (IIS)

When I try to run the index.php in the Admin directory via the browser to start the setup process, I get

Fatal error: Call to undefined function: odbc_pconnect() in /home/domains/2learn-homeopathy.co.uk/user/htdocs/moodle/lib/adodb/drivers/adodb-odbc.inc.php on line 116


Hopefully relevant information:
Part of my config.php is as follows
_________________________________________________
// First, you need to configure the database where all Moodle data
// will be stored. This database must already have been created
// and a username/password created to access it. See doc/INSTALL.

$CFG->dbtype = "Access"; // eg mysql (postgres7, oracle, access etc coming soon)
$CFG->dbhost = "localhost"; // eg localhost
$CFG->dbname = "moodle"; // eg moodle
$CFG->dbuser = "*******";
$CFG->dbpass = "******";


// Next you need to tell Moodle where it is located.
// Specify the full URL that moodle has been installed in:

$CFG->wwwroot = "http://www.2learn-homeopathy.co.uk/moodle";


// and now the full OS directory path to this same location:

$CFG->dirroot = "/home/domains/2learn-homeopathy.co.uk/user/htdocs/moodle";


// Now you need a place where Moodle can save uploaded files. This directory
// should be writeable by the web server user (usually 'nobody' or 'apache'),
// but it should not be accessible directly via the web.

$CFG->dataroot = "/home/domains/2learn-homeopathy.co.uk/user/private/moodledata";
________________________________________________


I have defined a blank Access database with appropriate User and Password and placed it in an hopefully appropriate directory. Is that enough? Do I need to create a blank Access database with all the relevant tables, primary keys etc?

We are not able to use MySql due to expense at present.

Any ideas would be gratefully received as I am an end-user rather than a techie and am "Drowning, not waving!!"

Many Thanks

Average of ratings: -
In reply to Kieran Foley

Re: Install probs / using an Access database

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
You may notice on the line where you defined the database type that mysql is the only supported option right now. Technically Moodle can support Access database in normal use, it just doesn't support CREATING the Access database automatically in the beginning. Someone would need to port the file lib/db/mysql.sql to lib/db/access.sql

Did you know that MySQL is completely free? smile

http://www.mysql.com/
In reply to Kieran Foley

Re: Install probs / using an Access database

by Claudio Tavares -
Hi Kieran

Did you made the access db?
I would like a copy or a help to buil one.
Tanks