Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by kage on Jan 20, 2010 07:16
open dhtmlx forum
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 
    WEB-INF\src\Scheduler_BasicConnector.java 
You need to use the same code , except of constructor line
   SchedulerConnector c = new SchedulerConnector(conn,DBType.MSSQL);

Sorry!

I have changed this flile.
    WEB-INF\src\Scheduler_BasicConnector.java 

SchedulerConnector c = new SchedulerConnector(conn);  ---->
SchedulerConnector c = new SchedulerConnector(conn,DBType.MSSQL);

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
Description: Incorrcet XML

Why?

Would we need use a sql script file of MsSQL?