I've done this - not specifically with AS400 - but with a couple of obscure databases.
Basically you need to work out ODBC part first. Get your basic connection working. Once that is done I recommend mx.ODBC as a good python interface that is the most robust I've found with commercial support if needed. The methodology I have used is one way sycnrohonisation of tables with selective mapping of fields. To get your orders back in is just a matter of determining that you can write to the AS/400 through the mx.ODBC connection and you know what tables and fields you are writing to, and the intricacies of the variant of sql it uses. Django would be perfect to add value to existing legacy databases this way, but I'm still trying to work out how I'm going to overcome the no 'read-only' field option in models in a sensible way if I am to migrate my own existing 'shop' projects to Django. Unfortunately the tool I have written has the commercial mx.ODBC library in it - so I can't release it unless I refactor it to use an open source library. On Sep 12, 6:50 am, Jason Sypolt <[EMAIL PROTECTED]> wrote: > Is it possible to connect to an as400 database using django > (preferably) or with python? I would like to build a product catalog > site using django and read in products and send orders to the as400. > > Note that the site itself will not be on an as400 system. Just > wondering if anyone has done this before and if so, can you point me > to some resources/libraries? Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
