How to compile FreeTDS on FreeBSD10.0-64 in a right way

Solution 1:

There is currently 2 ports for FreeTDS from the FreeBSD port tree:

• database/freetds which is indeed quite old (v 0.64)
• database/freetds-devel which is more in pair with the version you are mentioning.

New versions of FreeTDS do not create a shared library (.so) since quite a while as mentioned on FreeTDS site FAQ:

libtds.so doesn't exist and isn't needed. Any reference to it in your linker commands can be safely removed.

As of version 0.82, the TDS utility library is not built as a shared object. The static library libtds.a, is not installed by make install and is not needed by an applications that uses a client library (CT-Library, DB-Library, or ODBC). Because libtds is statically linked to the client libraries, they each now contain all the TDS functionality they need.

So now the question is what for are you needing such a new version, then how to update the client application to link to this new FreeTDS version.

If it is ODBC, there is also some hints regarding its configuration in the FreeTDS FAQ (...)