Server model is Classic ASP
Database is SQL 2012+
Test Connection returns OK status
Query Builder returns tables and columns, but cannot add any data to site.
http://localhost/test/dmxConnect/api/Data.asp returns the following error.
“errorNumber”:-2146823281,“message”:"‘sql.wheres.rules’ is null or not an object"
I don’t need a condition on the select statement, but added one anyway, now I get
“errorNumber”:-2147217900,“message”:“Incorrect syntax near ‘@P1’.”
I have never seen this with DMXZone DW extensions.
Any help would be appreciated.