问题描述
我正在使用以下内容:
DRIVER={Vertica ODBC Driver 4.1};
SERVER=lnxtabdb01.xxxx.com;
PORT=5433;
DATABASE=vertica;
USER=dbadmin;
PASSWORD=vertica;
OPTION=3;
我遇到此错误,我只是想确保我的连接字符串很酷,然后再检查其他可能的问题.
i'm getting this error and I just wanted to make sure that my connection string was cool before I check other possible issues.
错误:
EnvironmentError: System.Data.Odbc.OdbcException (0x80131937): ERROR [28000] FATAL: no Vertica user name specified in startup packet
更新:现在,我只是在可以使用的Windows Vista中使用系统数据源名称.但是我仍然想知道是否有一个odbc连接字符串,这样我就不必在将以这种方式连接到Vertica DB的每台计算机上进行设置.
UPDATE:For now i'm just using a System Data Source Name in Windows Vista that I can use. But i'd still like to know if there's an odbc connection string so that i don't have to set that up on every machine that will be connecting to the Vertica DB in this fashion.
好吧,我尝试了一个如下所示的postgresql连接字符串:
well, I tried a postgresql connection string that looks like this:
Host=lnxtabdb01.xxxx.com;
Port=5433;
Database=vertica;
User ID=dbadmin;
Password=vertica;
Pooling=true;
OPTION=3;
Min Pool Size=0;
Max Pool Size=100;
Connection Lifetime=0;
现在我得到了:
EnvironmentError: System.Data.Odbc.OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
推荐答案
我也没有看到在没有DSN的情况下使用ODBC的任何方法.这是我的Linux工作站的DSN设置.
I too have not seen any way to use ODBC without a DSN. Here's my DSN settings for my linux workstation.
[VerticaDSN]
Description = VerticaDSN ODBC driver
Driver = /opt/vertica/lib64//libverticaodbc_unixodbc.so
Database = Retail
Servername = localhost
UserName = vertica
Password =
Port = 5433
这篇关于有谁知道vertica的odbc连接字符串的格式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!