Dynamically exchange data between dhtmlx and ms acess

Suite and Optimus Suite 5
#1

Hello,

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?

Thanks

#2

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.

#3

Hello

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

Thanks

#4

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