[Asterisk-Users] MS SQL & Free TDS

[Tony Kava]

On 28 July 2004, Luke Cantranis wrote:
> 
> Help!
> I've been using mysql for cdr storage, I need to switch to MS 
> SQL. I must be
> stupid or something but I cannot figure out how to setup the 
> cdr_tds. I have
> FreeTDS configured properly, but my unixodbc is not working properly
> either... I'd be happy with either solution, but I'm in need 
> of assistance. 

Luke:

Did you setup a profile for the database server in your freetds.conf? I've
used FreeTDS with DBD::Sybase in the past, and although you can specify a
hostname in the application you are using that hostname is supposed to be a
profile name rather than an actual hostname.

You should have a profile in your freetds.conf that looks something like the
following:

[profile]
  host = host.domain.tld
  port = 1433
  tds version = 7.0
  try domain login = yes
  try server login = no
  nt domain = DOMAIN

If you have already setup a profile then please ignore this message.

Regards,

--
Tony Kava
Senior Network Administrator
Pottawattamie County, Iowa