[cisco-voip] SQL Query Rolls back Using UCCX DB Nodes

[shary shary]

hi all, i am facing a very strange issue in uccx while Reading or writing data into SQL DB from uccx DB Read and Write query.
For Read i am using the query "select * from tble where fil1=$customerinput" and for write "INSERT into tble (field1) Values (customerinput)" . When i test these queries it displays 1 row alterred while in at SQL side i can't see any new data. The DB guys are saying they are getting insert request from uccx but it rolls back intead of Commit. Same thing when i try to Read the data the call goes into success node but then from DB get node it passes from unsuccessful. Variable types are same at both side. What could e the issue. We are usign SQL ODBC connector. Your prompt will be appreaciateble.
 
thnx in advance 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20111102/4436d6bf/attachment.html>