05-11-2012 07:53 AM - edited 03-14-2019 09:50 AM
I have fullly connected to customer's external SQL Database via ODBC, and able to see all the tables in SQL Query Analyzer from the UCCX server. However, in CCX Script Editor, when trying to do a 'DB Read' step, the Database Source Name list empty. I've tried to 'Refresh Database Schema' many times, but no luck.
This is the first time customer has DB Source set up in the UCCX subsystem.
DB subsystem is running fine.
Has anyone see this before.
05-11-2012 07:58 AM
Hi,
Please see if the below links helps you.
https://supportforums.cisco.com/thread/2051690
http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_tech_note09186a008047bb4d.shtml
Thanks,
Anand
Pls rate helpful posts !!
05-11-2012 08:02 AM
Thank you Anand for your quickly response. However, I've checked all the above and they are setting corrected. I got my lab working, but not on customer production environment. So something is missing and I am checking allover again and again.
Thanks,
Binh.
05-11-2012 08:08 AM
Finally found it - forgot to set up same ODBC connection on the Secondary UCCX server. My lab is single PUB, and customer UCCX is HA environment.
After set up the same ODBC connection on the secondary UCCX server and Refresh DB Schema, everything is working fine now.
Thanks for any replies.
Binh.
05-11-2012 08:09 AM
Hi Binh,
Glad to know that
Thanks,
Anand
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide