« Back to General Discussion - All Versions

Connect VXML Server to Microsoft SQL 2000 for CVP 7.X and CVP 4.X

Combination View Flat View Tree View
Threads [ Previous | Next ]
Connect VXML Server to Microsoft SQL 2000 for CVP 7.X and CVP 4.X
Answer
8/7/08 10:58 PM
1. Download jdbc for mssql 2000 from microsoft and install on vxml server.

2. Get the jar files (3 files) from the dir where the setup install and copy under C:\Cisco\CVP\VXMLServer\Tomcat\common\lib

3. Open C:\Cisco\CVP\VXMLServer\Tomcat\conf\server.xml and add the following after <GlobalNamingResources>
<Resource name="jdbc/<giveMeAName>"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://<yourDBIPaddr>:1433;user=<user>;password=<pass>;DatabaseName=<your db>"
/>

4. Open C:\Cisco\CVP\VXMLServer\Tomcat\conf\context.xml and add the following

<ResourceLink global="jdbc/<giveMeAName>"" name="jdbc/<giveMeAName>"" type="javax.sql.DataSource"/>

5. Restart VXML Server

6. With Studio, create a database element where the JDBC name is <giveMeAName> , without jdbc/
Flag

Re: Connect VXML Server to Microsoft SQL 2000 for CVP 7.X and CVP 4.X
Answer
9/16/08 2:21 AM as a reply to Cory Wright.
The change to context.xml should read:
<ResourceLink global="jdbc/cvpdb" name="jdbc/cvpdb" type="javax.sql.DataSource" />

I overlooked the extra quotation marks in that line and that brought the VXML Server down. It restarted but Tomcat wasn't responding. After I removed the extra quotes, it restarted Ok.
Flag