On Fri, Feb 19, 2016 at 2:38 PM, Alex Hall <ah...@autodist.com> wrote:
> As the subject says, I am connected to our iSeries through straight > pyodbc. That seems to run perfectly. Now, is there a way to use SA > with that connection? When I use "ibm_db_sa+pyodbc://..." I get the > exact same error I was getting when using ibm_db directly. Using > pyodbc, I can specify the driver to be used, and I'm pretty sure > that's the key. > > Can I either use my pyodbc connection with SA and ibm_db_sa for the > dialect, or specify the driver to SA directly? Thanks! > > You can pass a "creator" argument to create_engine if you want to create the connection yourself: http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html#custom-dbapi-connect-arguments http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html#sqlalchemy.create_engine.params.creator Hope that helps, Simon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.