For using DHTMLX Gantt in ms access, I try to connect to our SQL database. But I always get the fault “invalid data”.
What am I doing wrong?
Hereby the code:
Planning.html:
How to Start with dhtmlxGantt html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; } gantt.config.xml_date = "%Y-%m-%d %H:%i"; gantt.init("gantt_here"); gantt.load('data.php');var dp=new dataProcessor("data.php");
dp.init(gantt);
</script>
data.php:
<?php include ("./codebase/connector/gantt_connector.php"); $dbtype = "MySQL"; $res=mysql_connect("FS-DRM-01/Snelstart", "sa", "******"); mysql_select_db("Planning"); $gantt = new JSONGanttConnector($res, $dbtype); $gantt->enable_log("log.txt,true"); $gantt->mix("open", 1); $gantt->render_links("dbo.gantt_links", "id", "source,target,type"); $gantt->render_table("dbo.gantt_tasks","id", "start_date,duration,text,progress,sortorder,parent",""); ?>