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 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 [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. >> > > -- > 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. > -- 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.
