概述
我目前拥有的：
/etc/odbcinst.ini
[HPVertica] Description = HP Vertica ODBC Driver Driver = /opt/vertica/lib64/libverticaodbc.so
/etc/odbc.ini
[ODBC Data Sources] VerticaDB1 = db1 database on HP Vertica [VerticaDB1] Description = db1 database on HP Vertica Driver = HPVertica Database = db1 Servername = 10.0.0.67 UID = dbadmin PWD = Port = 5433 Locale = en_GB [ODBC] Threading = 1
?/ .odbc.ini的
[DEFAULT] Driver = VerticaDB1
用isql测试
[root@ip-10-0-0-67 /]# echo "select 1;" | isql -v VerticaDB1 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ sql> select 1; +---------------------+ | ?column? | +---------------------+ | 1 | +---------------------+ sqlRowCount returns 1 1 rows fetched
odbcinst -j输出：
unixODBC 2.2.14 DRIVERS............: /etc/odbcinst.ini SYstem DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini sqlULEN Size.......: 8 sqlLEN Size........: 8 sqlSETPOSIROW Size.: 8
在使用“VerticaDB1”的Python中：
>>> import pyodbc
>>> conn = pyodbc.connect("DRIVER={VerticaDB1};UID={dbadmin};PWD={...}")
Traceback (most recent call last):
File "",line 1,in
pyodbc.Error: ('IM002','[IM002] [unixODBC][Driver Manager]Data source name not
found,and no default driver specified (0) (sqlDriverConnect)')在使用“HPVertica”的Python中：
>>> import pyodbc
>>> conn = pyodbc.connect("DRIVER={HPVertica};UID={dbadmin};PWD={...}")
Traceback (most recent call last):
File "",in
pyodbc.Error: ('HY000','[HY000] [unixODBC][Vertica][ODBC] (10430) Not enough
information provided to establish a connection to the data source and specified
to not prompt for more information. (10430) (sqlDriverConnect)')conn = pyodbc.connect("DSN=VerticaDB1;UID=dbadmin;PWD=mypassword")或者,您可以使用DRIVER进行连接,但需要提供更多信息,例如数据库,主机和端口：
conn = pyodbc.connect("DRIVER=HPVertica;SERVER=10.0.0.67;DATABASE=db1;PORT=5433;UID=dbadmin;PWD=mypassword")总结
以上是编程之家为你收集整理的python – 如何使用pyodbc连接到vertica全部内容，希望文章能够帮你解决python – 如何使用pyodbc连接到vertica所遇到的程序开发问题。
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群