MSAccess db

Scheduler Javascript
#1

Hello, i was wondering if there was any possibility to use a microsoft access database (mdb) as default db to insert, modify and delete scheduler events.
I read that the connector can partially handle MSAccess databases, but i didn’t understand how to implement it.

Thanks in advance.

#2

Are you using php?
Connector can be used with different DB types, and it can use PDO
docs.dhtmlx.com/doku.php?id=dhtm … ide_others

And you can configure PDO connection to msaccess db like
stackoverflow.com/questions/1605 … n-and-crud

#3

yes, i’m using php.
my connector.php is now like this:

<?php
require("codebase/grid_connector.php");
require("codebase/db_pdo.php");
 
$res = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=../mdb-database/test.mdb;Uid=Admin");
 
$schedulerConn = new SchedulerConnector($res,"PDO");
$scheduler->render_table("test","events,start_date,end_date");
?>

but i get an error saying “Error type: LoadXML Description : Incorrect XML”

#4

ok, i missed to include dhtmlxdataprocessor.js and connector.js :laughing:

now i receive another error: class PDO not found
this time i’m sure i’ve included db_pdo.php on the connector that is now this:

<?php
require("codebase/grid_connector.php");
require("codebase/db_pdo.php");
 
$res = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=../mdb-database/test.mdb");
	
	$scheduler = new schedulerConnector($res);
	//$scheduler->enable_log("log.txt",true);
	$scheduler->render_table("test");
?>

any suggestion?

#5

check php.ini
be sure that next two extensions are enabled

extension=php_pdo
extension=php_pdo_odbc

#6

i’m sorry, but i’m not expert with php configuration. i’m on a windows hosting server and i didn’t think i can modify the php.ini file.

my php configuration is http://62.149.131.199/ver.php