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
Thank you, Raymon! Your advise partially helped. Now I'm using following syntax: INSERT INTO [Samsung-DK](Question1) VALUES ($Var1) That is weard, it works in "Test" tab, but uploading script to CCX server this command does nothing. Do you have any clues?
... View more
Hello all! I am trying to write some data in external database from CCX script, but "DB Write" step always goes to "SQL Error" although I am using correct SQL syntax. I have checked it through MS SQL Management studio and everything works. Interesting is the fact, that "DB Read" step works fine!!! Another weard thing is that making test from "DB Write" step properties shows "Rows altered 1"... Nearby is commands I am trying to execute with no success: delete from [Samsung-DK] where Question1=150 and insert into Samsung-DK(Question1) values (200) I will very appreciate any help or advice, because I cannot find any clue in Cisco manuals. Thank you in advance.
... View more
Good day everyone! We have about 300 agents, who are using Cisco Agent Desktop and only 2 of them has the following issue. After successful login, CAD window minimizes and it cannot be restored. After ending CAD process and trying several times, CAD starts to run normaly. I have searched all over the internet, but couldn't find any solution for this problem. Maybe someone could help me in solving this? Thank you.
... View more