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 commercial project. When writing an ODBC dialect for SQLAlchemy you extend sqlalchemy.connectors.pyodbc.PyODBCConnector (or MxODBCConnector) for your dialect, you can look at the several pyodbc clients we have already (mssql, mysql, sybase) for examples.
The other advantage/disadvantage of ODBC is the usage of datasources. This is basically an extra layer of indirection between connect strings and an actual TCP hostname. Some setups allow the bypassing of the DSN and a lot of confusion comes from whether or not that is in use, since a lot of homegrowers impatiently try to skip that layer and get all confused. Its best to use externally configured DSNs when working with ODBC since that's how it was designed to be used. On Jan 18, 2011, at 6:51 PM, Warwick Prince wrote: > 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? Any advise / direction would be most appreciated when you > have a moment. > > Cheers from very wet Brisbane Australia. > > Warwick > > -- > 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 > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.