Plenty of resources on the web to show how to do that. XCode and the Command Line Tools already installed. This generates the odbc driver (xxx.so) which is not generated otherwise. The trick is to build FreeTDS with the the unixODBC switch. I wasted two days on this as well but did not want to use Homebrew or MacPorts. Now, $ isql -v SMS_GTWY username password returns: +-+ Isql works after reinstall unixodbc and freetds ( -with-unixodbc ): brew uninstall freetds USER DATA SOURCES.: /Users/horace/.odbc.ini
SYSTEM DATA SOURCES: /usr/local/Cellar/unixodbc/2.3.1/etc/odbc.iniįILE DATA SOURCES.: /usr/local/Cellar/unixodbc/2.3.1/etc/ODBCDataSources $ odbcinst -j returns: unixODBC 2.3.1ĭRIVERS.: /usr/local/Cellar/unixodbc/2.3.1/etc/odbcinst.ini There is a noticable difference, I do not see a libtdsS.so installed on OS X. I have a similar setup on CentOS and odbc isql to mssqlserver is working fine. While tsql is ok: $ tsql -S SERVER001 -U username -P passwordĭescription = MS SQL database access with FreeTDSįreetds and unixODBC are install by homebrew. Returns: Unable to connect to data source Odbc isql was unable to connect to data source: