cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
952
Views
7
Helpful
2
Replies

CVP integration with SQL Server 2012

zelino.rocha
Level 1
Level 1

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.

2 Replies 2

janinegraves
Spotlight
Spotlight

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).**

*

Janine, thanks for the information, it was useful!

Getting Started

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: