SOLVED - Help with Vertica connection
Hi,
I have added a Vertica Database driver, and the jdbc_properties.xml file in C:\users\<user name>\ now shows the following:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<drivers>
<driver dbnameseparator="/" defaultport="5433" driver_jar="C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar" drivers="com.vertica.jdbc.Driver" name="Vertica" urlprefix="jdbc:vertica://"/>
</drivers>
When I go to 'Manage Database Connections', and add a database connection, the URL defaults to jdbc:vertica://192.168.41.27:5433/cdrm
But when I click on 'Test Connection', it gives
"No suitable driver found for jdbc:vertica://192.168.41.27:5433/cdrm "
Will appreciate any help. I have successfully tested this same driver in "C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar" in DBVisualizer application.
Thanks!
I have added a Vertica Database driver, and the jdbc_properties.xml file in C:\users\<user name>\ now shows the following:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<drivers>
<driver dbnameseparator="/" defaultport="5433" driver_jar="C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar" drivers="com.vertica.jdbc.Driver" name="Vertica" urlprefix="jdbc:vertica://"/>
</drivers>
When I go to 'Manage Database Connections', and add a database connection, the URL defaults to jdbc:vertica://192.168.41.27:5433/cdrm
But when I click on 'Test Connection', it gives
"No suitable driver found for jdbc:vertica://192.168.41.27:5433/cdrm "
Will appreciate any help. I have successfully tested this same driver in "C:\Program Files (x86)\Vertica Systems\JDBC\vertica-jdk5-6.0.2-0.jar" in DBVisualizer application.
Thanks!