[sqlalchemy] Re: Debug ODBC Connection String for Custom Dialect

2018-01-14 Thread Chuanlong Du
Hi Lycovian, Can you share your dialect for Teradata using pyodbc? I'm very interested. Best, On Tuesday, January 13, 2015 at 8:34:33 AM UTC+8, Lycovian wrote: > > Looks like the *nix version of the ODBC driver I was using is simply > wrapping the Windows logic for parameters for DNS-less con

[sqlalchemy] Re: Debug ODBC Connection String for Custom Dialect

2015-01-12 Thread Lycovian
Looks like the *nix version of the ODBC driver I was using is simply wrapping the Windows logic for parameters for DNS-less connections contrary to the documentation For the record in Teradata for DNS-based connections the ODBC connection string would be on Linux: 'dsn=mydsn;Username=user;Passw

[sqlalchemy] Re: Debug ODBC Connection String for Custom Dialect

2015-01-11 Thread Lycovian
Thanks Mike (again). Working with Teradata's 3rd party ODBC drivers (DataDirect) has been illuminating. Looks like, contrary to the Teradata documentation, that on Linux via pyodbc they have wrapped the Windows version of their ODBC driver. UID/PWD as well as Username/Password both work as