Carlos Hanson wrote:

On Fri, May 16, 2008 at 8:14 AM, Michael Bayer <mike_mp <at> zzzcomputing.com> wrote:

On May 16, 2008, at 10:55 AM, Carlos Hanson wrote:

On Fri, May 16, 2008 at 6:13 AM, Jim Steil <steil <at> mailbag.com> wrote:

Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim

I'm connecting to an AS/400 using pyodbc, so I am sure that I can do it through SQLAlchemy. If I have a chances to test it, I'll post my success. But if you get an ODBC connection set up, the re should be no problem.

well, "connecting" is just the beginning. to take advantage of SQLA, you would also want an AS/400 dialect that knows how to render SQL in the way an AS/400 likes. Im not familiar with anyone working on an AS/ 400 dialect at the moment. I only know of the DB2 dialect which is a separate project (but maybe ask on their list since they work for IBM).

This is a good point. I have to create aliases to a file/member combination to select data. I guess I wouldn't expect SQLAlchemy to implement that by default, since most every other database uses tables.

Are you saying that you had to create aliases to make them work with pyodbc?  I don't have to create aliases but it works fine for me.  I do have to qualify with a library name, but that isn't too painful.

    -Jim


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy <at> googlegroups.com
To unsubscribe from this group, send email to sqlalchemy-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---