Working well so far on i386 connecting to MS Server 2008. Tested it using tsql and py-odbc.
Thanks, Ryan On Wed, Sep 8, 2010 at 3:27 AM, Stuart Henderson <s...@spacehopper.org> wrote: > if anyone's using freetds, please test and report back. > > Index: Makefile > =================================================================== > RCS file: /cvs/ports/databases/freetds/Makefile,v > retrieving revision 1.37 > diff -u -p -r1.37 Makefile > --- Makefile 1 Sep 2010 09:17:42 -0000 1.37 > +++ Makefile 8 Sep 2010 10:26:53 -0000 > @@ -3,11 +3,10 @@ > COMMENT= database drivers for Sybase/Microsoft SQL Server > > V= 0.82 > -PATCHVER= 20090903 > +PATCHVER= 20100728 > DISTNAME= freetds-$V > PKGNAME= ${DISTNAME}.1pre${PATCHVER} > -REVISION= 0 > -PATCHFILES= freetds-post82-${PATCHVER}.diff.fixed.gz:0 > +PATCHFILES= freetds-post82-${PATCHVER}.diff.gz:0 > > SHARED_LIBS += ct 4.0 # .4.0 > SHARED_LIBS += sybdb 6.0 # .5.0 > @@ -16,6 +15,8 @@ SHARED_LIBS += tdsodbc 0.0 > CATEGORIES= databases > > HOMEPAGE= http://www.freetds.org/ > +# or, if they lunch out the dns registration again: > +# http://freetds.schemamania.org/ > > # GPLv2+ > PERMIT_PACKAGE_CDROM= Yes > @@ -40,6 +41,9 @@ LIB_DEPENDS= ::databases/iodbc,-main \ > FLAVORS= msdblib > FLAVOR?= > > +# requires database server > +REGRESS_IS_INTERACTIVE=Yes > + > USE_LIBTOOL= Yes > CONFIGURE_STYLE= gnu > CONFIGURE_ARGS= ${CONFIGURE_SHARED} \ > @@ -71,7 +75,6 @@ post-install: > ${PREFIX}/share/examples/freetds/pool.conf-sample > �...@cd ${PREFIX}/lib && ln -s libtdsodbc.so.${LIBtdsodbc_VERSION} \ > libtdsodbc.so > - @mv ${PREFIX}/share/doc/freetds-$V.1.dev.20090930 \ > - ${PREFIX}/share/doc/freetds > + @mv ${PREFIX}/share/doc/freetds-* ${PREFIX}/share/doc/freetds > > .include <bsd.port.mk> > Index: distinfo > =================================================================== > RCS file: /cvs/ports/databases/freetds/distinfo,v > retrieving revision 1.14 > diff -u -p -r1.14 distinfo > --- distinfo 10 Oct 2009 14:16:55 -0000 1.14 > +++ distinfo 8 Sep 2010 10:26:53 -0000 > @@ -1,10 +1,10 @@ > MD5 (freetds-0.82.tar.gz) = Pfay6D/UIOkPG+y9EWKZCg== > -MD5 (freetds-post82-20090903.diff.fixed.gz) = LK7ChN+bZmxituREsHTxyw== > +MD5 (freetds-post82-20100728.diff.gz) = YJ7BviKjCBBZJy1gea+taQ== > RMD160 (freetds-0.82.tar.gz) = 01lsUSAiMyzbO6s3WVAVnx6TCks= > -RMD160 (freetds-post82-20090903.diff.fixed.gz) = FNzHR4oYLGFhr4GOX1lnL2zeVp8= > +RMD160 (freetds-post82-20100728.diff.gz) = eQaj378lJgQ4v/fUM+t+L+/16Mo= > SHA1 (freetds-0.82.tar.gz) = fioMnkHCQMLRx/acbyeOmlu4DC0= > -SHA1 (freetds-post82-20090903.diff.fixed.gz) = Oa3Ou0XIRhlaZEYJoRutg2mlmds= > +SHA1 (freetds-post82-20100728.diff.gz) = 0qS3IUiLJCKd7ynJbCj5OaRNc4A= > SHA256 (freetds-0.82.tar.gz) = 4nMUg2FL2ZLIyxM7zDhDLeE8+iQ8wTJ/N0EttQyZsrY= > -SHA256 (freetds-post82-20090903.diff.fixed.gz) = > uPcIKi1tcovRwWjm7p4tFKd9wt1g4PY+jin17qRJYBk= > +SHA256 (freetds-post82-20100728.diff.gz) = > F3mBqPzDxMYQG3ePydi5Foy2dU4Oss5X303+IYjmlLo= > SIZE (freetds-0.82.tar.gz) = 1596755 > -SIZE (freetds-post82-20090903.diff.fixed.gz) = 117703 > +SIZE (freetds-post82-20100728.diff.gz) = 57888 > Index: patches/patch-Makefile_in > =================================================================== > RCS file: /cvs/ports/databases/freetds/patches/patch-Makefile_in,v > retrieving revision 1.7 > diff -u -p -r1.7 patch-Makefile_in > --- patches/patch-Makefile_in 11 Oct 2009 16:33:36 -0000 1.7 > +++ patches/patch-Makefile_in 8 Sep 2010 10:26:53 -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-Makefile_in,v 1.7 2009/10/11 16:33:36 ajacoutot Exp $ > ---- Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ Makefile.in Sun Oct 11 18:21:53 2009 > -@@ -688,13 +688,6 @@ uninstall-info: uninstall-info-recursive > +--- Makefile.in.orig Wed May 7 23:59:24 2008 > ++++ Makefile.in Wed Sep 8 09:44:27 2010 > +@@ -687,13 +687,6 @@ uninstall-info: uninstall-info-recursive > > > install-data-local: > Index: patches/patch-configure > =================================================================== > RCS file: /cvs/ports/databases/freetds/patches/patch-configure,v > retrieving revision 1.5 > diff -u -p -r1.5 patch-configure > --- patches/patch-configure 11 Oct 2009 16:33:36 -0000 1.5 > +++ patches/patch-configure 8 Sep 2010 10:26:53 -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-configure,v 1.5 2009/10/11 16:33:36 ajacoutot Exp $ > ---- configure.orig Sun Oct 11 18:27:25 2009 > -+++ configure Sun Oct 11 18:28:01 2009 > -@@ -22997,8 +22997,8 @@ cat >>confdefs.h <<\_ACEOF > +--- configure.orig Wed May 7 23:59:26 2008 > ++++ configure Wed Sep 8 09:44:27 2010 > +@@ -22578,8 +22578,8 @@ cat >>confdefs.h <<\_ACEOF > #define HAVE_GNUTLS 1 > _ACEOF > > Index: patches/patch-odbc_unittests_Makefile_in > =================================================================== > RCS file: > /cvs/ports/databases/freetds/patches/patch-odbc_unittests_Makefile_in,v > retrieving revision 1.5 > diff -u -p -r1.5 patch-odbc_unittests_Makefile_in > --- patches/patch-odbc_unittests_Makefile_in 11 Oct 2009 16:33:36 -0000 > 1.5 > +++ patches/patch-odbc_unittests_Makefile_in 8 Sep 2010 10:26:53 -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-odbc_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36 > ajacoutot Exp $ > ---- src/odbc/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ src/odbc/unittests/Makefile.in Sun Oct 11 18:21:53 2009 > -@@ -1015,7 +1015,7 @@ check-am: all-am > +--- src/odbc/unittests/Makefile.in.orig Wed May 7 23:59:20 2008 > ++++ src/odbc/unittests/Makefile.in Wed Sep 8 09:44:27 2010 > +@@ -1006,7 +1006,7 @@ check-am: all-am > check: check-am > all-am: Makefile > installdirs: > Index: patches/patch-src_ctlib_unittests_Makefile_in > =================================================================== > RCS file: > /cvs/ports/databases/freetds/patches/patch-src_ctlib_unittests_Makefile_in,v > retrieving revision 1.5 > diff -u -p -r1.5 patch-src_ctlib_unittests_Makefile_in > --- patches/patch-src_ctlib_unittests_Makefile_in 11 Oct 2009 16:33:36 > -0000 1.5 > +++ patches/patch-src_ctlib_unittests_Makefile_in 8 Sep 2010 10:26:53 > -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-src_ctlib_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36 > ajacoutot Exp $ > ---- src/ctlib/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ src/ctlib/unittests/Makefile.in Sun Oct 11 18:21:53 2009 > -@@ -736,7 +736,7 @@ check-am: all-am > +--- src/ctlib/unittests/Makefile.in.orig Wed May 7 23:59:18 2008 > ++++ src/ctlib/unittests/Makefile.in Wed Sep 8 09:44:27 2010 > +@@ -735,7 +735,7 @@ check-am: all-am > check: check-am > all-am: Makefile > installdirs: > Index: patches/patch-src_dblib_unittests_Makefile_in > =================================================================== > RCS file: > /cvs/ports/databases/freetds/patches/patch-src_dblib_unittests_Makefile_in,v > retrieving revision 1.5 > diff -u -p -r1.5 patch-src_dblib_unittests_Makefile_in > --- patches/patch-src_dblib_unittests_Makefile_in 11 Oct 2009 16:33:36 > -0000 1.5 > +++ patches/patch-src_dblib_unittests_Makefile_in 8 Sep 2010 10:26:53 > -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-src_dblib_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36 > ajacoutot Exp $ > ---- src/dblib/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ src/dblib/unittests/Makefile.in Sun Oct 11 18:21:53 2009 > -@@ -785,7 +785,7 @@ check-am: all-am > +--- src/dblib/unittests/Makefile.in.orig Wed May 7 23:59:19 2008 > ++++ src/dblib/unittests/Makefile.in Wed Sep 8 09:44:27 2010 > +@@ -784,7 +784,7 @@ check-am: all-am > check: check-am > all-am: Makefile > installdirs: > Index: patches/patch-src_pool_Makefile_in > =================================================================== > RCS file: /cvs/ports/databases/freetds/patches/patch-src_pool_Makefile_in,v > retrieving revision 1.4 > diff -u -p -r1.4 patch-src_pool_Makefile_in > --- patches/patch-src_pool_Makefile_in 11 Oct 2009 16:33:36 -0000 1.4 > +++ patches/patch-src_pool_Makefile_in 8 Sep 2010 10:26:53 -0000 > @@ -1,7 +1,7 @@ > $OpenBSD: patch-src_pool_Makefile_in,v 1.4 2009/10/11 16:33:36 ajacoutot Exp > $ > ---- src/pool/Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ src/pool/Makefile.in Sun Oct 11 18:21:53 2009 > -@@ -530,10 +530,7 @@ uninstall-am: uninstall-binPROGRAMS uninstall-info-am > +--- src/pool/Makefile.in.orig Wed May 7 23:59:21 2008 > ++++ src/pool/Makefile.in Wed Sep 8 09:44:27 2010 > +@@ -529,10 +529,7 @@ uninstall-am: uninstall-binPROGRAMS uninstall-info-am > > > install-data-local: > Index: patches/patch-src_tds_unittests_Makefile_in > =================================================================== > RCS file: > /cvs/ports/databases/freetds/patches/patch-src_tds_unittests_Makefile_in,v > retrieving revision 1.5 > diff -u -p -r1.5 patch-src_tds_unittests_Makefile_in > --- patches/patch-src_tds_unittests_Makefile_in 11 Oct 2009 16:33:36 -0000 > 1.5 > +++ patches/patch-src_tds_unittests_Makefile_in 8 Sep 2010 10:26:53 -0000 > @@ -1,6 +1,6 @@ > $OpenBSD: patch-src_tds_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36 > ajacoutot Exp $ > ---- src/tds/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009 > -+++ src/tds/unittests/Makefile.in Sun Oct 11 18:21:53 2009 > +--- src/tds/unittests/Makefile.in.orig Wed May 7 23:59:22 2008 > ++++ src/tds/unittests/Makefile.in Wed Sep 8 09:44:27 2010 > @@ -198,7 +198,7 @@ INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@ > LDFLAGS = @LDFLAGS@ > LIBICONV = @LIBICONV@ > @@ -10,7 +10,7 @@ $OpenBSD: patch-src_tds_unittests_Makefi > LIBTOOL = @LIBTOOL@ > LN_S = @LN_S@ > LTLIBICONV = @LTLIBICONV@ > -@@ -624,7 +624,7 @@ check-am: all-am > +@@ -623,7 +623,7 @@ check-am: all-am > check: check-am > all-am: Makefile > installdirs: > Index: pkg/PLIST > =================================================================== > RCS file: /cvs/ports/databases/freetds/pkg/PLIST,v > retrieving revision 1.15 > diff -u -p -r1.15 PLIST > --- pkg/PLIST 10 Oct 2009 14:16:55 -0000 1.15 > +++ pkg/PLIST 8 Sep 2010 10:26:53 -0000 > @@ -181,8 +181,83 @@ ${DOC}/reference/tab_r.gif > ${DOC}/reference/tabs.css > ${DOC}/reference/todo.html > ${DOC}/userguide/ > +${DOC}/userguide/about.htm > +${DOC}/userguide/aboutunicode.htm > +${DOC}/userguide/acknowledgments.htm > +${DOC}/userguide/advocacy.htm > +${DOC}/userguide/apireference.htm > +${DOC}/userguide/appendmode.htm > +${DOC}/userguide/askingforhelp.htm > +${DOC}/userguide/build.htm > +${DOC}/userguide/choosingtdsprotocol.htm > +${DOC}/userguide/config.htm > +${DOC}/userguide/configs.htm > +${DOC}/userguide/confirminstall.htm > +${DOC}/userguide/contrib.htm > +${DOC}/userguide/contributors.htm > +${DOC}/userguide/ctlib.api.summary.htm > +${DOC}/userguide/dblib.api.summary.htm > +${DOC}/userguide/domains.htm > +${DOC}/userguide/dsnless.htm > +${DOC}/userguide/envvar.htm > +${DOC}/userguide/freetdsconf.htm > +${DOC}/userguide/freetdshistory.htm > +${DOC}/userguide/gfdl-1.htm > +${DOC}/userguide/gfdl-10.htm > +${DOC}/userguide/gfdl-11.htm > +${DOC}/userguide/gfdl-2.htm > +${DOC}/userguide/gfdl-3.htm > +${DOC}/userguide/gfdl-4.htm > +${DOC}/userguide/gfdl-5.htm > +${DOC}/userguide/gfdl-6.htm > +${DOC}/userguide/gfdl-7.htm > +${DOC}/userguide/gfdl-8.htm > +${DOC}/userguide/gfdl-9.htm > +${DOC}/userguide/gfdl.htm > +${DOC}/userguide/help.htm > ${DOC}/userguide/index.htm > ${DOC}/userguide/index.html > +${DOC}/userguide/install.htm > +${DOC}/userguide/interfacesfile.htm > +${DOC}/userguide/interfacesformat.htm > +${DOC}/userguide/interfaceslocation.htm > +${DOC}/userguide/interfacespurpose.htm > +${DOC}/userguide/iso8859.htm > +${DOC}/userguide/locales.htm > +${DOC}/userguide/localization.htm > +${DOC}/userguide/logging.htm > +${DOC}/userguide/mailinglist.htm > +${DOC}/userguide/odbc.api.summary.htm > +${DOC}/userguide/odbcconnattr.htm > +${DOC}/userguide/odbcdiagnose.htm > +${DOC}/userguide/odbcinionly.htm > +${DOC}/userguide/odbcombo.htm > +${DOC}/userguide/osissues.htm > +${DOC}/userguide/packages.htm > +${DOC}/userguide/pagenodata.htm > +${DOC}/userguide/perl.htm > +${DOC}/userguide/php.htm > +${DOC}/userguide/portoverride.htm > +${DOC}/userguide/prepodbc.htm > +${DOC}/userguide/programming.htm > +${DOC}/userguide/projects.htm > +${DOC}/userguide/python.htm > +${DOC}/userguide/samplecode.htm > +${DOC}/userguide/seemtooslow.htm > +${DOC}/userguide/serverthere.htm > +${DOC}/userguide/software.htm > +${DOC}/userguide/stunnel.htm > +${DOC}/userguide/sybsql.htm > +${DOC}/userguide/tdshistory.htm > +${DOC}/userguide/tdspool.htm > +${DOC}/userguide/troubleshooting.htm > +${DOC}/userguide/unicode.htm > +${DOC}/userguide/unicodefreetds.htm > +${DOC}/userguide/unicodegoodbad.htm > +${DOC}/userguide/unicodeutf.htm > +${DOC}/userguide/usefreetds.htm > +${DOC}/userguide/userguide.css > +${DOC}/userguide/what.htm > share/examples/freetds/ > share/examples/freetds/freetds.conf-sample > �...@sample ${SYSCONFDIR}/freetds.conf > > -- Thanks, Ryan