Please help, trying to use koolgrid with SQL server and I'm having a hard time finding any documentation for connecting to a SQL server. I tried SQLSRVDatasource and SQLDatasource and neither work. I know I can connect because the connection for the pivot table to sql works...$ds = new SQLSRVPivotDataSource($dbcon);. What is the correct way to designate a datasource for SQL server in koolgrid? (btw, I really wish your forums had a search engine.)
Thanks.
Found it...sorry
require "KoolControls/KoolGrid/ext/datasources/SQLSRVDataSource.php";

Hi Daniel,
If you had a sqlsrv connection to your MS SQL Server, please include the file KoolGrid/ext/datasources/SQLSRVDataSource.php and use the connection to create the datasource:

$ds = new $SQLSRVDataSource($sqlsrvConn);

Please let us know if you need further information. Thanks!