Error while connecting to vertica from cognos(IBM cognos connect)

Indu_Ezhilarasa

Hi,
I am getting " you are not licensed to use this ODBC driver".Please find below for the configuration and error message in detail.Request your advice.

Error Message:

UDA-SQL-0107 A general exception has occurred during the operation "attach".
[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased.  If you wish to purchase a license, then you may use the Driver Manager for a period of 15 days, during which time you are required to obtain a license.  You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere.  Thank you for your cooperation.
BME-EX-0144 Trace back:

I used "vertica-client-6.1.3-0.x86_64.tar.gz" to install vertica.

Configuration:
[cognos@****s]# more vertica.ini
[Driver]
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib/libodbcinst.so.1
ErrorMessagesPath=/opt/vertica/lib
LogLevel=4
LogPath=/tmp

[cognos@****~]$ more .odbc.ini
[ODBC]
InstallDir=/usr/odbc

[ODBC Data Sources]
VerticaDSN=libverticaodbc.so

[VerticaDSN]
Description=VerticaDSN ODBC driver
Driver=/opt/vertica/lib/libverticaodbc.so
Database=
Servername=
UserName=
Password=
Port=5433

[cognos@**** ~]$ more odbcinst.ini
[ODBC]
Threading = 1

[HPVertica]
Description=HP Vertica ODBC Driver
Driver=/opt/vertica/lib/libverticaodbc.so

.Bash_profile under /opt/cognos.

export=$LD_LIBRARY_PATH:/opt/vertica/lib
export PATH=$PATH:/opt/vertica/bin

ODBCINI=/opt/cognos/.odbc.ini
export ODBCINI
VERTICAINI=/opt/cognos/vertica.ini
export VERTICAINI

Thanks,
Indu.

Indu_Ezhilarasa

Hi Amelia Cohen, Can you please guide me to fix this issue?

Indu_Ezhilarasa

Hi Amelia Cohen, Can you please guide me to fix this issue?

Myles_Collins_1

This was problem with the DataDirect driver manager from Progress. It is fixed now in DataDirect 7.1.2 .