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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
