09-30-2014 02:39 AM
Hi,
I need to implement a CVP script that does some queries to a database that is running on a SQL Server 2012.
I've seen some documentation and a driver and configuration to the context.xml file are referred.
This is the first link:
http://docwiki.cisco.com/wiki/Unified_CVP_VXML_Server_JNDI_Resources
That refers this one:
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#MySQL_DBCP_Example
In the second one I don't see information about the driver to install to integrate to SQL Server 2012, neither the configuration of the context.xml file for SQL Server. Should I use the ones referred to MySQL or is there specific ones for SQL Server 2012?
Also, the VXML Server is already running Tomcat by default or should I do anything to enable Tomcat to be running?
Can you help?
Thanks in advance.
09-30-2014 05:27 AM
You should just be able to download the driver from the internet - just
search for SQL Server 2012 JDBC driver. Then store it into the
VXMLServer/Tomcat/common/lib directory.
To configure the context.xml file for SQL Server - it's not exactly the
same as MySql.
You can try the one listed on StackOverflow.com
http://stackoverflow.com/questions/7930450/tomcat-jndi-connection-with-ms-sqlserver-2008-r2-issue
Or try this:
*After installing the driver and modifying context.xml you'll need to
reboot (or stop/start the CVP VXML Server Service, which isn't always so
easy).**
*
10-02-2014 07:43 AM
Janine, thanks for the information, it was useful!
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: