Re: Connecting to AS400

2008-09-12 Thread Brett H
Yes - the trick is with slow odbc interfaces is to differentiate between auto-increment/log style source tables and those which may update any record. Also try and pick your tables and fields to sync judiciously and work out your sync cycle based on how expensive in time it is to retrieve all the

Re: Connecting to AS400

2008-09-12 Thread Jarek Zgoda
Wiadomość napisana w dniu 2008-09-11, o godz. 22:50, przez Jason Sypolt: > 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. DB2/400 is

Re: Connecting to AS400

2008-09-11 Thread Brett H
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

Re: Connecting to AS400

2008-09-11 Thread Jon Brisbin
I don't think Django can natively use unixODBC as it's ORM backend, unfortunately. It would be great if it did! You could Django without the ORM, of course. To connect from a Win server (why would want to do that? ;), you could use ClientAccess. To connect from Linux, you could use IBM's

Connecting to AS400

2008-09-11 Thread Jason Sypolt
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