Connectivity Issue with MSSQL using FREETDS

Hi to all

I am using asterisk 1.6 with freetds 0.91 version.When i am trying to connect Sql server with UNIXODBC driver i am getting error like this

echo “select 1” | isql -v asterisk-connector
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[ISQL]ERROR: Could not SQLConnect

I am getting connecting

/usr/bin/tsql -S -U user

when i am trying

isql -v sqlexpress devuser
error message like follow

[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

And configuration files


host =
port = 1433
tds version = 8.0


Description = MS SQL connection to ‘asterisk’ database
Driver = FreeTDS
Database = DB
Server =
UserName = user
Password = ***
Trace = No
TDS_Version = 8.0
Port = 1433


Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No

Description = ODBC for Microsoft SQL
Driver = /usr/local/lib/
UsageCount = 1
Threading = 2

Can any pls give the solution for this problem i am strucked here from long time.

Thanks & Regards,