[asterisk-users] MSSQL connection

[Kevin Smith]

Hi everyone,

I am looking to log CDR records to our MSSQL database for further 
examination on the records. From what I gathered from the wiki I have to 
choose between FreeTDS and unixODBC. Is there a better choice? Which 
option would be better in the log run?

Also configuration asterisk to use both modules. Any good tips on that, 
I followed the steps provided by the following pages:

http://www.voip-info.org/wiki/view/FreeTDS
http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc

But this is the error I get: (note: some information has been changed 
for security, such as 'user' and pass was changed to phone)

# isql -v MSSQL-astersik phone phone
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
[][unixODBC][FreeTDS][SQL Server]Login failed for user 'phone'.
[][unixODBC][FreeTDS][SQL Server]Cannot open database requested in login 
'cdr'.
Login fails.
[ISQL]ERROR: Could not SQLConnect

from odbcinst
[MSSQL-FreeTDS]
Description     = FreeTDS ODBC driver for MSSQL
Driver          = /usr/lib/libtdsodbc.so
Setup           = /usr/lib/libtdsS.so
FileUsage       = 1

from odbc
[MSSQL-asterisk]
description     = Asterisk ODBC for MSSQL
driver          = MSSQL-FreeTDS
server          = XXX.XXX.XXX.XXX
port            = 1433
database        = cdr
user            = phone
password        = phone
tds_version     = 7.0
language        = us_english


Maybe I am just overlooking something or there is something that isn't 
registering with me that is under my nose. Any help would be 
appreciated. My guess is it is an error between the keyboard and chair  ;).

Thanks,
Kevin