[Asterisk-Dev] Problem connecting sip.conf to ODBC

[Federico Alves]

I have HEAD installed and I am stuck trying to connect my sip.conf to SQL
Server using ODBC FreeTDS. I use the driver through Perl and it works fine,
but I can not figure this problem out. The question is: how the file
res_odbc.conf must look like?


Mar 16 11:53:08 NOTICE[11290]: res_odbc.c:133 load_odbc_config: registered
database handle 'minixel' dsn->[minixel]
Mar 16 11:53:08 NOTICE[11290]: res_odbc.c:382 odbc_obj_connect: Calling
0x8122ee8/0x8122ef8
Mar 16 11:53:08 WARNING[11290]: res_odbc.c:392 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
Mar 16 11:53:08 NOTICE[11290]: res_odbc.c:426 load_module: res_odbc loaded.
 [res_config_odbc.so] => (ODBC Configuration)
Mar 16 11:53:08 NOTICE[11290]: config.c:847 ast_config_engine_register:
Registered Config Engine odbc
res_config_odbc loaded.

My res_odbc.conf is:

[minixel]
dsn => minixel
Port => 1433
username => minixel
password => xxxxxx
pre-connect => yes

my /usr/local/etc/odbc.ini

[MSSQL]
Driver		= FreeTDS
Description		= Sybase JDBC Server
Trace		= Yes
Servername		= minixel
Port	=1433
Database		= minixel
UID		= minixel
Password		= xxxxxx


My /usr/local/etc/freetds.conf has this entry:

[minixel]
	host = minixel
	port = 1433
	tds version = 8.0