[BangPypers] pyodbc Teradata connection

JAGANADH G jaganadhg at gmail.com
Thu Apr 18 13:18:40 CEST 2013


Hi ,
Does anybody have experience with pyodbc and teradata .
I was trying to connect to a remote teredata instance using pyodbc. it
gives the following error.

 Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified  (SQLDriverConnect)')


The connection string is
pyodbc.connect("DRIVER={Teradata};DBCNAME=DB;UID=UU;PWD=PW",
autocommit=True,ansi=True)


Any clue on how to resolve the same .


Best regards




-- 
**********************************
JAGANADH G
http://jaganadhg.in
*ILUGCBE*
http://ilugcbe.org.in


More information about the BangPypers mailing list