We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Unable to See rows using isql using ODBC connection for Vertica — Vertica Forum

Unable to See rows using isql using ODBC connection for Vertica

I have created a connection and I am able to connect to the database using that. But when I select records from the table it is not coming up.

[dbadmin@Vertica sql]$ cat /etc/odbc.ini
[ODBC Data Sources]
VerticaDSN = "sfpdb database"
[VerticaDSN]
Description = SFP Database
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = sfpdb
Servername = 16.181.233.133
UserName = dbadmin
Password = sfpdb
Port = 5433

[dbadmin@Vertica ~]$ isql -v VerticaDSN
+---------------------------------------+
| Connected!                               |
|                                                   |
| sql-statement                            |
| help [tablename]                       |
| quit                                            |
|                                                   |
+---------------------------------------+
SQL> select * from t;
+---------------------+|
a                             |
+---------------------+|
|1                            |
|
|
+----------------------+
SQLRowCount returns 3
3 rows fetched

Not sure whey I am unable to see all the three rows.

RPM: vertica-6.1.3-0
unixODBC-2.2.11-7.1
RHEL 5.5

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file