RESOLVED : Creating a Vertica datasource

[sdf]

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