[MacPorts] #32706: py27-odbc can't find MacPorts ODBC drivers on 10.7

[MacPorts]

#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