Bug 230553 – pyodbc (New package)

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Alec Shaner 2008-07-02 18:27:23 UTC]

pyodbc is a python ODBC driver that works in conjunction with unixODBC and freetds (both in portage) to provide access to MSSQL databases. It would be cool to have an ebuild for it in portage.

Reproducible: Always




I have installed pyodbc manually and connected to a SQL Server 2005 database from both an x86 gentoo system and a amd64 gentoo system. This required the dev-db/unixODBC and dev-db/freetds packages, and freetds had to have the "odbc" USE flag.

pymssql is a simple alternative that's already in portage, but does not seem to have the maturity or features of pyodbc.

[Comment 1 Jeroen Roovers (RETIRED) 2009-05-06 21:43:58 UTC]

*** Bug 268830 has been marked as a duplicate of this bug. ***

[Comment 2 Alec Shaner 2009-05-07 13:01:58 UTC]

Created attachment 190615 [details]
pyodbc-2.1.5.ebuild

Attaching the ebuild created for duplicate bug #268830

[Comment 3 Michael Yang 2009-07-12 19:12:50 UTC]

the SRC_URI has one too many slashes, preventing digest creation.  I renamed the ebuild pyodbc-2.1.6.ebuild and removed the extra slash.  ebuild pyodbc-2.1.6.ebuild digest then works correctly.

Why hasn't anybody uploaded this ebuild to dev-db?

 pyodbc-2.1.5.ebuild pyodbc-2.1.6.ebuild
--- pyodbc-2.1.5.ebuild 2009-07-12 15:10:47.000000000 -0400
+++ pyodbc-2.1.6.ebuild 2009-07-12 15:06:12.000000000 -0400
@@ -9,7 +9,7 @@

 DESCRIPTION="python ODBC module to connect to almost any database"
 HOMEPAGE="http://code.google.com/p/pyodbc/"
-SRC_URI="http://pyodbc.googlecode.com/files//${P}.zip"
+SRC_URI="http://pyodbc.googlecode.com/files/${P}.zip"

 LICENSE="MIT"
 SLOT="0"

[Comment 4 ron widler 2009-09-12 15:24:36 UTC]

Created attachment 203865 [details]
Version bump: ebuild for pyodbc-2.1.6

bumped ebuild for pyodbc to 2.1.6, removed the extra slash as well
builds fine on my amd64~

[Comment 5 Longpoke 2010-05-26 13:16:27 UTC]

Tested and working on amd64 with basic SELECT, INSERT, and UPDATE statements on postgresql and sqlite databases with the following packages:

dev-python/pyodbc-2.1.6
dev-db/psqlodbc-08.02.0500
dev-db/sqliteodbc-0.83
dev-db/postgresql-8.1.11
dev-db/sqlite-3.6.22-r2
dev-lang/python-2.6.5-r2

[Comment 6 Alexandre Nuno Milheiro 2011-03-25 00:32:28 UTC]

Created attachment 267145 [details]
ebuild fro pyodbc 2.1.8 without deprecated NEED_PYTHON_2.4 var

You can use get pyodbc from my overlay on git://github.com/bdx/bdxol.git

[Comment 7 Jesus Rivero (RETIRED) 2011-03-25 15:10:07 UTC]

Hi there, 

Thanks for your contributions. dev-python/pyodbc-2.1.8 is now in the tree. Alexandre, please take a look at the final ebuild to watch for the changes based on new python.eclass. Thanks a lot for your ebuild. 

Alec and Ron, thanks for your work, keep 'em coming.

Best regards,