CVP integration with SQL Server 2012

[zelino.rocha]

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.

[janinegraves]

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

*

[zelino.rocha]

Janine, thanks for the information, it was useful!