[MacPorts] #32706: py27-odbc can't find MacPorts ODBC drivers on 10.7
MacPorts
noreply at macports.org
Sat Dec 31 15:47:24 PST 2011
#32706: py27-odbc can't find MacPorts ODBC drivers on 10.7
--------------------------------+-------------------------------------------
Reporter: bpanulla@… | Owner: singingwolfboy@…
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version: 2.0.3
Keywords: pyodbc | Port: py27-odbc
--------------------------------+-------------------------------------------
Old description:
> 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.
New description:
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 [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.
--
Comment(by ryandesign@…):
Your patch hardcodes /opt/local; you must instead arrange to use the
current value of ${prefix}.
--
Ticket URL: <https://trac.macports.org/ticket/32706#comment:2>
MacPorts <http://www.macports.org/>
Ports system for Mac OS
More information about the macports-tickets
mailing list