Re: [sqlalchemy] Simplified Pyodbc Connect Questions

2014-10-24 Thread Lycovian
Thanks for the reply Mike. I've been tracking SQLAlchemy for years now and it's probably some of the best code, docs, and support I've ever seen. Yes, I have verified that pyodbc and the pooling flag work: In [1]: import pyodbc In [2]: pyodbc.pooling = False In [3]: conn = pyodbc.connect

Re: [sqlalchemy] Simplified Pyodbc Connect Questions

2014-10-24 Thread Michael Bayer
You probably need to hit that flag early before anything connects. A safe place would be in the dbapi() accessor itself, or in the __init__ method of the dialect class. Sent from my iPhone On Oct 24, 2014, at 1:32 PM, Lycovian mfwil...@gmail.com wrote: Thanks for the reply Mike. I've

[sqlalchemy] Simplified Pyodbc Connect Questions

2014-10-23 Thread Lycovian
Is there a way to use a pyodbc connection without a dialect? I'd prefer to not have to create a custom dialect to talk to my Teradata server as I have gotten pyodbc to work well. Seems like since ODBC is a standard that I might be able to get enough functionality out of it. Is this even

Re: [sqlalchemy] Simplified Pyodbc Connect Questions

2014-10-23 Thread Michael Bayer
On Oct 23, 2014, at 2:50 PM, Lycovian mfwil...@gmail.com wrote: Is there a way to use a pyodbc connection without a dialect? there is not. the dialect is responsible for formulating SQL of the format that the database understands as well as dealing with idiosyncrasies of the DBAPI driver