Hi everyone! I have found that was the problem and a solution for this. Decided to post solution here, just in case someone will experience the same. The problem was that CCX Script editor can't interconnect different SQL version syntax. On the server, running CCX, I have MS SQL Server 2000, but on the server, running data base, MS SQL Server 2008 is installed. That is interesting, adding ODBC object successed through Administration Tools, but running SQL through scripts reverted to SQL error. Solution is to install ODBC driver for SQL 2008, create new ODBC object with this driver and everything works with no problems.
... View more