unixODBC 在运行 isql [Vertica] 时出错 [英] unixODBC giving error while running isql [Vertica]

问题描述

我已经在 Ubuntu 10.10 32 位版本机器中为 vertica 配置了 DSN 设置.设置都很好，我已经对它们进行了交叉检查.

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and I have cross checked them.

这是我的 odbc.ini 文件:

Here is my odbc.ini file:

 [VerticaDSN]
  Description = VerticaDSN ODBC driver
  Driver = /opt/vertica/lib/libverticaodbc_unixodbc.so
  Servername = myservername
  Database = mydbname
  Port = 5433
  UserName = myuname
  Password = *******
  Locale = en_US

同样，我有一个 odbcinst.ini 文件.

Similarly I have a odbcinst.ini file.

当我运行命令时:isql -v VerticaDSN 我收到以下错误:

when I run the command: isql -v VerticaDSN I get the following error:

 [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.

我已尝试了所有方法，但无法破译此错误.

I have tried everything but I am not able to decipher this error.

任何帮助将不胜感激.

推荐答案

您可能缺少驱动程序配置部分.使用以下内容编辑或创建文件/etc/vertica.ini:

You may be missing the Driver configuration section. Edit or create the file /etc/vertica.ini with the following content:

[Driver]
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp

更多信息可以在 Vertica 程序员指南的附加驱动程序设置的位置"部分找到.

More information can be found in the Vertica Programmer's Guide in the section "Location of the Additional Driver Settings".

这篇关于unixODBC 在运行 isql [Vertica] 时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！