Scheduler how to return events from SQLSrv

Scheduler Javascript
#1

I am trying to return events from SQLSrv and continue to receive a 500 error. I first suspected the connection to my db but I believe it is now correctly configured. Am I missing a required javascript file? Below are my events.php and the page where the scheduler is rendered.

Using SQL Server 12.0.2000.8 & PHP 5.6

[code]
events.php

<?php include('dhtmlxScheduler\codebase\connector\scheduler_connector.php'); include("dhtmlxScheduler\codebase\connector\db_sqlsrv.php"); $connectionInfo = array("Database" => "dbName","UID" => "username", "pwd" => "password"); $serverName = 'server address'; $res = sqlsrv_connect($serverName, $connectionInfo) or die("Unable to connect"); $scheduler = new schedulerConnector($res, "SQLSrv"); $scheduler->render_table("test","id","start_date,end_date,description"); ?>[/code]

[code]
availability.php

<!doctype html>


title

<script src="dhtmlxscheduler/codebase/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"></script>

<script src="dhtmlxscheduler/codebase/sources/ext/dhtmlxscheduler_minical.js" type="text/javascript" charset="utf-8"></script>
<script src="dhtmlxscheduler/codebase/sources/ext/dhtmlxscheduler_recurring.js" type="text/javascript" charset="utf-8"></script>
<script src="dhtmlxscheduler/codebase/sources/ext/dhtmlxscheduler_year_view.js" type="text/javascript" charset="utf-8"></script>
<script src="dhtmlxScheduler/samples/common/dhtmlxCommon/dhtmlxcommon.js" type="text/javascript" charset="utf-8"></script>
<!--dataprocessor-->
<script src="dhtmlxScheduler/samples/common/dhtmlxCommon/dhtmlxdataprocessor.js" type="text/javascript" charset="utf-8"></script>
<!--connector
<script src="data/connector.js" type="text/javascript" charset="utf-8"></script>-->

<link rel="stylesheet" href="dhtmlxscheduler/codebase/dhtmlxscheduler.css" type="text/css" charset="utf-8">

<style type="text/css">
    html,
    body {
        margin: 0px;
        padding: 0px;
        height: 80%;
    }
</style>

<?php include_once 'header.php'; ?>
<div class="col-md-12">
    <body onload="init();">
        <div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:750px; margin-bottom:1%;'>
            <div class="dhx_cal_navline">		
                <div class="dhx_cal_prev_button">&nbsp;</div>
                <div class="dhx_cal_next_button">&nbsp;</div>
                <div class="dhx_cal_today_button"></div>
                <div class="dhx_cal_date"></div>
                <div class="dhx_minical_icon" id="dhx_minical_icon" onclick="show_minical()">&nbsp;</div>
                <div class="dhx_cal_tab" name="year_tab" style="right:330px;"></div>
                <div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
                <div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
                <div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
            </div>
            <div class="dhx_cal_header">
            </div>
            <div class="dhx_cal_data">
            </div>
        </div>
        <?php include_once 'footer.php'; ?>
    </body>
</div>
</html>[/code]
#2

Hi,

  1. do you see any error message in server output of connector file?
  2. please try enabling connector logging - docs.dhtmlx.com/connector__php_ … #enablelog - are there any errors in the log?
#3

I ended up switching from SQLSrv to a MySql backend. Once I made the switch and included the correct files, it worked perfectly.