Dynamically exchange data between dhtmlx and ms acess


Can someone help me in getting the sample code which will help me establish the connection between dhtmlx front end and ms access db(back end). I am primarily looking for dynamic data exchange between these two.

Does this require any software instalations?


You can use php or java version of connectors
PHP can use PDO with ODBC connection type
Java connector can use JDBC access driver

After creating the connection - you can use default connector’s logic for all operations.


thanks for the response. Do you have any sample code for PHP with ODBC connection type .


There is no ready sample, but you can use something like next to create connection object

$pdo = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\xampp\htdocs\access\test.mdb;Uid=Admin");

And after that continue with normall connector init code

docs.dhtmlx.com/doku.php?id=dhtm … ide_others