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 192.168.1.1 -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
freetds.conf
[asterisk-connector]
host = 192.168.1.1
port = 1433
tds version = 8.0
odbc.ini.conf
[asterisk-connector]
Description = MS SQL connection to ‘asterisk’ database
Driver = FreeTDS
Database = DB
Server = 192.168.1.1
UserName = user
Password = ***
Trace = No
TDS_Version = 8.0
Port = 1433
odbcinst.ini.conf
[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No
[FreeTDS]
Description = ODBC for Microsoft SQL
Driver = /usr/local/lib/libtdsodbc.so
UsageCount = 1
Threading = 2
Ctrl+D
Can any pls give the solution for this problem i am strucked here from long time.
Thanks & Regards,
Vishnu