#32706: py27-odbc can't find MacPorts ODBC drivers on 10.7 --------------------------------+------------------------------------------- Reporter: bpanulla@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.0.3 Keywords: pyodbc | Port: py27-odbc --------------------------------+------------------------------------------- The current version of py27-odbc doesn't find ODBC drivers in /opt/local, failing with the classic and super-informative 'Data source name not found, and no default driver specified'. I've tried it with both the mysql-odbc-connector port and my psqlODBC port (still [https://trac.macports.org/ticket/31282 waiting to be approved]). I can connect to the data sources using the MacPorts unixODBC isql client without issue, so this is definitely a problem in pyodbc. I *think* this was previously working under Snow Leopard, but I can't be sure and I don't have a system running that anymore. I got a hint to the problem from a [http://stackoverflow.com/questions/7881985/using-alternate-unixodbc- installation Stack Overflow question/answer] that led me to a solution. Attached are an updated Portfile and a new setup.py.patch that adds MacPorts library and include paths to the build process. Alas, I've also included an upgrade to pyodbc 2.1.11. The current version (2.1.8) is quite old and I couldn't see how to accomplish what I needed to do against the old codebase. I f someone who knows more about the build process can tease these two patches apart into one, go for it. -- Ticket URL: <https://trac.macports.org/ticket/32706> MacPorts <http://www.macports.org/> Ports system for Mac OS