Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Jaimy Azle
Actually the ibm_db_sa support several methods to connect to iSeries; natively through ibm_db, pyodbc, or jdbc (with jython). On Jun 8, 2014 8:53 AM, Cory Lutton cory.lut...@gmail.com wrote: Thanks for such a quick reply. Great to hear that I am starting out on the right path with building a

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Cory Lutton
Looks like I wasn't looking at it correctly then... What I did so far lets it pass through statements using execute() which is what I need for now but at least I know not to spend much more time on it. I just took another look at the ibm_db_sa and installed it but it seems to have Python 3

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Jaimy Azle
The iSeries support of ibm_db_sa has not been tested on python3 when I write it. On Jun 12, 2014 4:04 AM, Cory Lutton cory.lut...@gmail.com wrote: Looks like I wasn't looking at it correctly then... What I did so far lets it pass through statements using execute() which is what I need for

[sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-07 Thread Cory Lutton
I have been looking at using sqlalchemy in an internal company cherrypy application I am working on. It will need to interface with my companies iSeries server in order to use ERP data. I have been using pyodbc so far and everything works great. I am thinking of adding access to another

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-07 Thread Michael Bayer
On Jun 7, 2014, at 8:27 PM, Cory Lutton cory.lut...@gmail.com wrote: I have been looking at using sqlalchemy in an internal company cherrypy application I am working on. It will need to interface with my companies iSeries server in order to use ERP data. I have been using pyodbc so far

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-07 Thread Cory Lutton
Thanks for such a quick reply. Great to hear that I am starting out on the right path with building a dialect, I have some work to do so I just wanted to make sure I wasn't missing something before I spend the time. Hopefully I can get things working enough where I can post it somewhere. I