While I find the video on setting up the connector very simple to follow for PHP and a MySQL database, I am not getting what I am missing in setting this up for ColdFusion and Microsoft SQL Server. I am trying to use the Contacts application that was built in the sample coding and modifying to just learn this, but not getting something.
I have the grid initialized and appearing in the layout, and have the grid looking to load from a cfm file called griddata.cfm.
In the griddata.cfm file, I have the include to the config.cfm file and the following statements that I am guessing provide the connection string information for the database:
<cfset grid = createObject(“component”,“dhtmlxConnectors.GridConnector”).init(“#AppCon#”,“MSSQL”)>
<cfset config = createObject(“component”,“dhtmlxConnectors.GridConfiguration”).init(“#AppCon#”,“MSSQL”)>
with a render table statement as follows:
In the config.cfm file, I have:
<cfset request.dhtmlxConnectors[“datasource”] = “AppCon”> and
<cfset request.dhtmlxConnectors[“db_type”] = “MSSQL”>
Again not sure what else that I am supposed to do with this. I have the following file structure:
At the root:
[dhtmlConnector]-with all of the CFC files.
I had contacted support last year and have a string of emails that lead me to believe I was supposed to do something within ColdFusion Administration.
I have a 32 bit and 64 bid ODBC connector on the webserver to connect to the SQL server that both work in other applications. I have a Data Source within CF Administration using the ODBC Socket. All three called AppCon.
What am I missing or have I not configured properly.