Carlos Hanson wrote: > On Fri, May 16, 2008 at 8:14 AM, Michael Bayer <[EMAIL PROTECTED]> wrote: > >> On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: >> >> >>> On Fri, May 16, 2008 at 6:13 AM, Jim Steil <[EMAIL PROTECTED]> 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@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---