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