Can't connect to Vertica database

Moderator: NorbertKrupa

Post Reply
banurajadurai
Newbie
Newbie
Posts: 21
Joined: Tue Aug 27, 2013 10:31 am

Can't connect to Vertica database

Post by banurajadurai » Thu Nov 14, 2013 7:01 am

Hi m using 3 node vertica (ex: node A B C).
m trying to connect to Vertica database from perl code from Node A . i installed all ODBC drivers .
Now when executing perl code m not able to connect to db, its throwing error as
DBI connect('VerticaDSN','tdaadmin',...) failed: [unixODBC][Vertica][ODBC] (10380) Unable to establish a connection with data source. (SQL-08001) at test.pl line 5
Can't connect to Vertica database: [unixODBC][Vertica][ODBC] (10380) Unable to establish a connection with data source. (SQL-08001)


Can anyone help me please :-(

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Can't connect to Vertica database

Post by JimKnicely » Thu Nov 14, 2013 2:47 pm

Are you able to connect using isql?

isql -v VerticaDSN
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Perl”