Error message NoSQLGetPrivateProfileString

[Josh]

Hi,

I am trying to set up an ODBC connection to Vertica on a 32-bit Linux box. I installed the Vertica ODBC driver using the vertica_5.1.5_odbc_i386_linux.tar.gz file downloaded from Vertica.

When I try and connect with isql I get an error:

Code: Select all

[root@COGNOS1 etc]# isql -v vertica_test
[S1000][unixODBC][DSI] The error message NoSQLGetPrivateProfileString could not be found in the en-US locale. Check that /en-US/ODBCMessages.xml exists.
[ISQL]ERROR: Could not SQLConnect

My DSN in the /etc/odbc.ini file looks like this:

Code: Select all

[vertica_test]
Driver = /opt/vertica/lib/libverticaodbc.so
Servername = 10.XXX.XX.XXX
Database = vert1
Port = 5433
UserName = smiley
Password = cookie

Any idea what's going on?

Thanks.

[id10t]

Any idea what's going on?

keywords: vertica.ini
http://my.vertica.com/docs/CE/5.1.1/HTM ... #17045.htm

[JimKnicely]

A side note on this topic...

When setting up the Vertica ODBC 5.1 driver initially, I also experienced the same error as Josh. Once I added the additional ODBC driver configuration settings in an /etc/vertica.ini file and set the VERTICAINI environment variable to point to the file, the connection to Vertica worked as expected.

Whats interesting is that afterwards I found that I could delete the /etc/vertica.ini file and set the VERTICAINI variable to nothing and my connection would still work.

Here are my current settings odbc.ini file contents:

Code: Select all

[root@CUBEBUILDER01 etc]# cat odbc.ini
[verticatst01]
Driver = /opt/vertica/lib/libverticaodbc.so
Servername = verticatst01
Database = vertica01
Port = 5433
UserName = cognos
Password = xxxxx

Note that /opt/vertica/lib/libverticaodbc.so links to libverticaodbc.so.5.1.5:

Code: Select all

[root@CUBEBUILDER01 etc]# ls -lrt /opt/vertica/lib/libverticaodbc.so
lrwxrwxrwx 1 root root 23 May 23 07:04 /opt/vertica/lib/libverticaodbc.so -> libverticaodbc.so.5.1.5

My VERTICAINI environment variable is now set to nothing:

Code: Select all

[root@CUBEBUILDER01 etc]# echo $VERTICAINI

[root@CUBEBUILDER01 etc]

But I can still connect:

Code: Select all

[root@CUBEBUILDER01 etc]# isql -v verticatst01
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select count(*) from tables;
+---------------------+
| count               |
+---------------------+
| 214                 |
+---------------------+
SQLRowCount returns 1
1 rows fetched

I found this to be interesting. I wonder if the setting were added to some underlying ODBC config file?

[jpcavanaugh]

Looks like you are hitting this issue - http://my.vertica.com/forums/topic/odbc ... #post-3062