In order to ge tthis to work , needed to add the MS JBBC driver
Step 1: To add a new JDBC Driver
Open the jdbcDriver.xml file:
If you are using Tomcat as your application server (the default):
On Windows: \tomcat\webapps\vizserver\xmldata
On Solaris: /tomcat/webapps/vizserver/xmldata
If you are using WebSphere as your application server:
On Windows: \vizserver.ear\vizserver.war\xmldata
On Solaris: /vizserver.ear/vizserver.war/xmldata
If you are using WebLogic as your application server:
On Windows: \weblogic81\server\lib
On Solaris: \weblogic81\server\lib
Add the following lines to the file for each new driver:
classname of driver
driver url
Properly increase the number.
Edit the parameter to reflect the new driver's class name.
Edit the parameter with the default URL for the driver.
Stop and then restart VizServer.
Step 2: To make the JDBC driver available to VizServer
You must make this new driver available to VizServer as you have done with the default drivers, see Making JDBC Drivers Available to VizServer.