Categories | Question details Back To List | ||
How to use dhtmlxScheduler with MSSQL Now, we can use dhtmlxConnector_java to connect mysql . we change file, DataBaseConnection.java , to use mssql. Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=test", "sa", ""); What can I do for useing dhtmlxScheduler with MSSQL or other database? Thanks! Answer posted on Jan 20, 2010 08:31 Check WEB-INF\src\Scheduler_BasicConnector.java You need to use the same code , except of constructor line SchedulerConnector c = new SchedulerConnector(conn,DBType.MSSQL); Answer posted by Kage on Jan 20, 2010 23:24 Check Sorry! I have changed this flile. SchedulerConnector c = new SchedulerConnector(conn); ----> I change these code , in some file. src\Scheduler_BasicConnector.java src\Scheduler_RecConnector.java But I can't use dhtmlxScheduler with MsSQL. Why?? (I converted MySQL databases into MS SQL format with tools that is MySQL-to-MSSQL.) Answer posted by Stanislav (support) on Jan 21, 2010 01:48 >>But I can't use dhtmlxScheduler with MsSQL. What kind of problem is occurs ? Does some java level problem or data just not shown in the browser? Answer posted by Kage on Jan 21, 2010 05:56 There is not any exception with out in tomcat 6.0. use scheduler/recurring_events/sample_recurring.html in IE, we see: Error type: LoadXML Why? Would we need use a sql script file of MsSQL? |