Hi,
I have installed the vertica client/drivers to my system.
I added a DSN and testing it is successful, also able to use vsql.
But when i try to add a datasource using ODBC, testing the connection returns to failed.
I cannot seem to find the logs referring to datasource connections.
Is there anything that i could check to move forward with this issue?
Resolution :
1. uninstalled the vertica client/driver 7.0 32_64
2. download and install 32bit vertica client
3.Created DSN in syswow64 odbc
4. copy the vertica-jdbc jar file from vertica systems to <cognos_home>\c10_64\webapps\p2pd\WEB-INF\lib