FreeTDS Development Group

[Merle Reinhart <merlereinhart AT mac.com>]

Frediano,

Yes, Apple has deprecated a number of open source packages including iODBC.  
They are still including the libraries to allow older apps to continue 
running, but have removed the include files so that new apps can’t use the 
built-in libraries.

They took that stance several versions of OS X ago.  Since then, I’ve been 
building iODBC myself (I use the source tarball from iodbc.org) and linking 
FreeTDS successfully against that.  My configure line for iODBC is:

sh bootstrap.sh
./configure --prefix=/usr/local/iodbc --with-iodbc-inidir=/Library/ODBC 
--disable-gui CFLAGS="-arch i386 -arch x86_64"


I also build against the Fink libraries (should work with MacPorts and 
HomeBrew as well) which pulls in a newer readline, a newer libiconv, recent 
openssl, etc.

The configure line I use for FreeTDS is:

./configure --with-iodbc=/usr/local/iodbc --enable-sybase-compat 
--prefix=/usr/local/freetds --with-libiconv-prefix=/sw --disable-debug 
--disable-server --disable-pool --enable-krb5 CC=clang

This works well for use where I work.  We use sqsh for sql access, odbc 
access via python/pyodbc, tcl tdbc and via lisp.  The databases we access are 
Sybase and MS SQL with Mac OS X, Linux and Solaris.

I’m not sure what to suggest for a FreeTDS build on Mac OS X without any 
additional external packages as I’m not sure how many features would have to 
be
left behind in that situation (or if would work at all given what Apple as 
deprecated and will likely completely remove in a future OS release).

Merle



 

> On Jun 12, 2016, at 10:50 AM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 
> 2016-06-11 8:58 GMT+01:00 Frediano Ziglio <freddy77 AT gmail.com>:
>> Hi Merle,
>>  thanks to test it out. I think now the big concern about Mac OS X is
>> the OpenSSL support removal from Apple. Would be great to have the
>> support for Mac OS X system libraries for TLS support.
>> I have a Mac so I could try however I was not able to compile FreeTDS
>> with iODBC. I also installed iODBC (why is not included by default?)
>> but FreeTDS was not finding the headers/library. Should I add some
>> option?
>> 
> 
> I tried with the Mac OS X and I would have some feedback...
> - the iODBC library is contained in the Essential package (libiodbc.dylib);
> - Essential package contains pkgconfig file (int /usr/lib/pkgconfig)
> but not pkg-config script;
> - Xcode does not contain pkg-config either;
> - Apple removed isql.h and other iODBC include files from Xcode MacOSX
> 10.8 include directory. Also they removed iodbc-config. Did they
> decide to deprecate iODBC?
> - I installed iODBC PKG from iODBC website. The isql.h include try to
> include a <iODBC/sql.h> as isql.h is not supported anymore however
> there is no iODBC directory/link which contains a sql.h so the include
> fails!
> 
> Looks like they are trying to make thing much harder for developers :-(
> 
> Not counting that my PKG database has still Xcode MacOSX 10.8 files
> but files are not present anymore.
> 
>> Recently I had a report stating that ODBC on Mac OS X is compiling as
>> module instead of library causing some problems. I don't know if the
>> DM load drivers as module or as library. Actually there is no such
>> difference on other operating systems. What the difference between a
>> module and a library on Mac OS X?
>> Looking at 
>> http://stackoverflow.com/questions/2339679/what-are-the-differences-between-so-and-dylib-on-osx
>> looks like module were required for dynamic loading. Nowadays however
>> dynamic libraries work always. I think the best option would be to use
>> modules if DM is used or library otherwise taking attention to link
>> only to DM instead of module.
>> 
> 
> Frediano
> 
>> 
>> 2016-06-10 15:10 GMT+01:00 Merle Reinhart <merlereinhart AT mac.com>:
>>> Frediano,
>>> 
>>> That tarball fixes the compile issue at least on Mac OS X 10.11.x (El 
>>> Capitan).  Thanks!!!
>>> 
>>> It turns out the problem would only occur when compiling FreeTDS with 
>>> iodbc.  It was fine compile with unixodbc.  I finally tracked down 'why' 
>>> it occurs.
>>> 
>>> In iodbc, the sql.h include calls sqltypes.h which calls iodbcunix.h 
>>> which has a conditional definition of BYTE:
>>> #if defined (OBSOLETE_WINDOWS_TYPES)
>>> typedef unsigned char           BYTE;
>>> #endif
>>> 
>>> 
>>> In unixodbc, the sql.h include calls sqltypes.h which contains an 
>>> unconditional definition of BYTE:
>>> typedef unsigned char           BYTE;
>>> 
>>> So, the compile would fail using iodbc apparently due to 
>>> OBSOLETE_WINDOWS_TYPES not being defined anywhere, but would work using 
>>> unixodbc.
>>> 
>>> I was just about to report the exact same issue when I saw Ryan's mail.
>>> 
>>> 
>>> Again, thank you very much for all the work.
>>> 
>>> Merle
>>> 
>>> 
>>> 
>>>> Message: 6
>>>> Date: Fri, 10 Jun 2016 11:59:50 +0100
>>>> From: Frediano Ziglio <freddy77 AT gmail.com>
>>>> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
>>>> Subject: Re: [freetds] OSX distribution
>>>> Message-ID:
>>>>      <CAHt6W4e0QrzuEAK8Gi4g1a9PxuN3uckDxeG1zi9M7xd7U_d40A AT mail.gmail.com>
>>>> Content-Type: text/plain; charset=UTF-8
>>>> 
>>>> 2016-06-06 12:25 GMT+01:00 Ryan Schmidt <freetds AT ryandesign.com>:
>>>>> 
>>>>> On Jun 6, 2016, at 5:06 AM, Frediano Ziglio wrote:
>>>>> 
>>>>>> 2016-06-05 20:17 GMT+01:00 Igor Korot <ikorot01 AT gmail.com>:
>>>>>>> Hi, ALL,
>>>>>>> Is there a dmg file to download for the release?
>>>>>>> 
>>>>>>> Thank you.
>>>>>> 
>>>>>> There is actually not any official Mac OS X release package.
>>>>> 
>>>>> I'm the maintainer of freetds in the MacPorts package management 
>>>>> system, and unfortunately, I've found that freetds 1.00 does not 
>>>>> compile on OS X. (0.95.x versions did.) The error is:
>>>>> 
>>>>> 
>>>>>   In file included from odbc.c:51:
>>>>>   ../../include/odbcss.h:300:8: error: unknown type name 'BYTE'
>>>>>           const BYTE * colptr;
>>>>>                 ^
>>>>>   ../../include/odbcss.h:305:29: error: unknown type name 'BYTE'
>>>>>   bcp_colptr(HDBC hdbc, const BYTE * colptr, int table_column)
>>>>>                               ^
>>>>>   ../../include/odbcss.h:343:8: error: unknown type name 'BYTE'
>>>>>           const BYTE * varaddr;
>>>>>                 ^
>>>>>   ../../include/odbcss.h:346:8: error: unknown type name 'BYTE'
>>>>>           const BYTE * terminator;
>>>>>                 ^
>>>>>   ../../include/odbcss.h:353:27: error: unknown type name 'BYTE'
>>>>>   bcp_bind(HDBC hdbc, const BYTE * varaddr, int prefixlen, int varlen,
>>>>>                             ^
>>>>>   ../../include/odbcss.h:354:8: error: unknown type name 'BYTE'
>>>>>           const BYTE * terminator, int termlen, int vartype, int 
>>>>> table_column)
>>>>>                 ^
>>>> 
>>>> 
>>>> Could you try 
>>>> ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.1.tar.bz2 ?
>>>> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds