Applies To:
  • CitectSCADA 3.30 4.10

When you run SQLExec() with the function SQLSelect* an error is returned that the function is not supported. The customer is using MS-SQL ODBC driver and he states it does support it. Is this caused by Citect not supporting it and what functions are supported with the SQLExec() function.  

The problems with Citect executing select statements on SQL server via microsofts ODBC driver are caused by outdated Intersolv libraries. We have new libraries and have verified that they fix the problem. These shall be put into the next release build.

CIT has confirmed this to be a problem in Citect for Windows version 3.30 and 4.10. This problem has been fixed in version 3.40 and 4.20.