Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2013-02-22 Thread Femi Anthony
Hi, I know this is a long time, but did you ever get SQLAlchemy to successfully work with Vertica ? Please let me know as I am interested in doing the same. Thanks, Femi Anthony On Tuesday, February 2, 2010 11:37:15 AM UTC-5, Bo wrote: Hi Michael, Thanks for the tip on dialect creation; I

Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-02-02 Thread Bo Shi
Hi Michael, Thanks for the tip on dialect creation; I have a working connection and much of the low level library functionality appears to just work. I've just started digging into the internals to begin implementing introspection support. One issue I've encountered is that PyODBC happens to

[sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-01-15 Thread Bo Shi
Hi All, I'm attempting to get rudimentary support for a Vertica deployment using an ODBC connector. According to their docs, their dialect is mostly compatible with Oracle and SQLServer dialects. create_engine() using 'mssql+pyodbc' seems to work but upon attempting to execute a simple select

Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-01-15 Thread Michael Bayer
Bo Shi wrote: Hi All, I'm attempting to get rudimentary support for a Vertica deployment using an ODBC connector. According to their docs, their dialect is mostly compatible with Oracle and SQLServer dialects. That's funny because Oracle and SQL server are utterly, totally different from a

Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-01-15 Thread Bo Shi
That's funny because Oracle and SQL server are utterly, totally different from a SQL quirks perspective.   If I were to pick two dialects in SQLA that were *most* different from each other and also non-standard, those would be the two. I was a bit puzzled by this also (granted this was from