import sqlalchemy as sa
conn = "vertica+pyodbc://dbadmin:password@VMart"
sa.create_engine(conn, pool_size=10, max_overflow=20)
%load_ext sql
%sql vertica+pyodbc://VMart
error
(pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
(0) (SQLDriverConnect)')
(Background on this error at: http://sqlalche.me/e/rvf5)
Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname<br>
or an existing connection: dict_keys([])
First
import sqlalchemy as sa
import urllib
sa.create_engine('vertica+vertica_python://dbadmin:[email protected]:5433/VMart')
%load_ext sql
%sql vertica+pyodbc://VMart
Second
import sqlalchemy as sa
sa.create_engine('vertica+vertica_python://dbadmin:password@VMart')
import pyodbc
Third
conn = pyodbc.connect("DRIVER=Vertica;SERVER=192.168.11.132;DATABASE=VMart;PORT=5433;UID=dbadmin;PWD=password")
same error
error but I already test vertica odbc in windows10. It connect
successfuled
(pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
(Background on this error at: http://sqlalche.me/e/rvf5)
Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname
or an existing connection: dict_keys([])
Copyright Notice：Content Author:「Chiramet Charoennakasit」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/57390853/how-to-connect-python-with-vertica-using-odbc