PyTd icon indicating copy to clipboard operation
PyTd copied to clipboard
verified publisher icon Teradata

The default driver selected when TPT is installed is not correct.

Open escheie opened this issue 7 years ago • 2 comments

The logic for choosing the default driver to use when one is not specified does not work when TPT is installed. This is because it registers additional drivers with the Driver Manager that contain "Teradata" but that are not a valid Teradata ODBC driver. E.g.

teradata.api.DatabaseError:
(1207, '[HY000] [TPT][ODBC PostgreSQL Wire Protocol driver] Connection refused. Verify Host Name and Port Number.,
[TPT][ODBC PostgreSQL Wire Protocol driver] Invalid attribute in connection string: DBCNAME.,
[TPT][ODBC PostgreSQL Wire Protocol driver] Invalid attribute in connection string: SESSIONMODE.')

escheie avatar May 11 '18 23:05 escheie

I seem to have this issue but in my case this is surfacing when trying to connect via Sqlalechemy. I have Sqlalchemy-Teradata installed but I am not sure how to specify the driver to use in the Sqlalchemy URI. Any suggestions?

pwsnla avatar May 31 '18 15:05 pwsnla

@sandan Do you know if there is a way to specify the driver option to PyTd when using sqlalchemy-teradata?

escheie avatar May 31 '18 17:05 escheie