Unix DB server communicating to MSSQL

sometimes business may want your unix database server to communicate with MSSQL to produce valuable reports real-time on the fly.
Batch reconcilation is not a choice so you must install FreeTDS to talk to MSSQL.

In our example, DB server was Oracle database running on Solaris SPARC server.
We installed UnixODBC and FreeTDS packages from OpenCSW website.
Then below working config is critical and it is only shown in this article.

Point to emphasize is; 
	TDS must be 64-bit if Oracle DB is running 64-bit.
	TDS must be 32-bit if Oracle DB is running 32-bit.
Only exception is Oracle 10g but it is already out-of-support. 
(TDS must be 32-bit either Oracle 10g is 32-bit or 64-bit)

At Solaris, libraries under "sparc" folder are 32-bit but libraries under "sparcv9" are 64-bit
libtdsodbc.so in below example is 64-bit as it is under sparcv9 folder because Oracle db was 64-bit 11g.

		Feel free to communicate by bulent.yucesoy@gmail.com

root@server1:/etc/opt/csw# cat odbc.ini
[ODBC Data Sources] 
MSSQLTest=MS SQL Server 

[MSSQLTest]
DRIVER=/opt/csw/lib/libtdsodbc.so
Description=SQL Server connection
Database=HR
LogonID=hr
Password=PASSWORD
Server=DBServer,1453
QuotedId=YES
AnsiNPW=YES
TDS_Version = 8.0
asdfClient_CSet=ISO-8859-9
QueryTimeout=0
root@server1:/etc/opt/csw# cat odbcinst.ini
[TDS]
Driver=/opt/csw/lib/sparcv9/libtdsodbc.so
TDS_Version = 8.0
root@server1:/etc/opt/csw#