Building libtdsS.so on Mac OS X

A Jesse Jiryu Davis <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Dear friends,

SUMMARY:  I'd like to try the latest version of FreeTDS,
freetds-0.83.dev.20101013, but when I build it there's a library
missing.  I think I need libtdsS.so, but when I build the source I
don't get that file.  Are there particular arguments for the configure
script, or something else I need to do to build the latest library?

DETAILS:  My system uses Python 2.7, pyodbc 2.1.8 on Mac OS X 10.6.4.
I installed the stable version (0.82) of FreeTDS using HomeBrew.  Then
I write this in
odbcinst.ini:

[SQL Server]
Description = FreeTDS Driver
Driver = /usr/local/Cellar/freetds/0.82/lib/libtdsodbc.0.so
Setup = /usr/local/Cellar/freetds/0.82/lib/libtdsS.so
UsageCount = 1

I have a problem with this setup:  Executing a particular SELECT
statement throws this:

               Error: ('IM001', '[IM001] [unixODBC][Driver
Manager]Driver does not
support this function (0) (SQLColAttribute)')

... so I thought I'd try the latest version of FreeTDS.  I downloaded
the source and tried various ./configure options, and no matter what I
do no libtdsS.so is generated by 'make'.  I've also tried substituting
libtdsodbc.0.so for libtdsS.so, like so:

[SQL Server]
Description = FreeTDS Driver
Driver=/usr/local/lib/libtdsodbc.0.so
Setup=/usr/local/lib/libtdsodbc.0.so
UsageCount = 1

... but that causes this error:

               Could not connect with connection string:
SERVER=10.1.XXX.XXX;UID=XXX;PWD=XXX;DRIVER={SQL Server}

So it looks like I really need libtdsS.so.  How do I build it for version 0.83?

Thanks!
Jesse
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.