search

Teradata / PyTd

A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
MIT License
108 stars 43 forks source link

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

Open escheie opened 6 years ago

escheie commented 6 years ago

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.')
pwsnla commented 6 years ago

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?

escheie commented 6 years ago

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