Connectivity Guide > Understanding ODBC Connectivity > Connecting from Python
Was this helpful?
Connecting from Python
You can connect to the Actian Data Platform through ODBC using Python and pyodbc.
You can get pyodbc at https://pypi.org/project/pyodbc/. Creating a DSN is explained at https://www.actian.com/company/blog/integrating-python-vector-actianx/.
The following is a portion of the odbc.ini file with a vnode example:
[avalanche]
Driver=/opt/Actian/Vector_Client/ingres/lib/libiiodbcdriver.1.so
Vendor=Actian Corporation
DriverType=Ingres
Server=avalanche_vnode
Database=db
ListenAddress=VW
ServerType=Ingres
where avalanche_vnode is the Actian Data Platform vnode.
The following is a sample connection script:
# -*- coding: utf-8 -*-
 
import pyodbc as pdb
 
#using vnode as described above
#conn = pdb.connect("dsn=avalanche;uid=dbuser;pwd=password")
 
#or direct connection without vnode
conn= pdb.connect("driver=Ingres;servertype=ingres;server=@localhost,tcp_ip,VW;uid=dbuser;pwd=password;database=db")
 
More information:
 
Last modified date: 01/04/2024