[sqlalchemy] ODBC general question

2011-01-18 Thread Warwick Prince
Hi All We need to connect to a Progress database, and we are in the very early days of this. I understand it supports an ODBC interface and therefore should be able to be connected to using SA - correct? Are there any limitations on the ODBC connector or gotcha's that we should look out for?

Re: [sqlalchemy] ODBC general question

2011-01-18 Thread Michael Bayer
pyodbc works very well, as does mxodbc which is commercial. Most issues have to do with using ODBC from unix, where if we're working for free we use FreeTDS, that has a lot of quirks. There are commercial ODBC drivers for unix which I haven't used but we will be using them soon for a

Re: [sqlalchemy] ODBC general question

2011-01-18 Thread Warwick Prince
Hi Michael Thanks yet again for excellent advice provided in a timely manner! :-) Cheers Warwick On 19/01/2011, at 10:25 AM, Michael Bayer wrote: pyodbc works very well, as does mxodbc which is commercial. Most issues have to do with using ODBC from unix, where if we're working for free