# Asterisk realtime not working

**URL:** <https://community.asterisk.org/t/asterisk-realtime-not-working/32568>\
**Category:** Asterisk Support\
**Created:** [September 15, 2010, 1:09pm UTC](https://community.asterisk.org/t/asterisk-realtime-not-working/32568 "2010-09-15T13:09:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![venablc](https://avatars.discourse-cdn.com/v4/letter/v/ac91a4/32.png) [@venablc](https://community.asterisk.org/u/venablc)\
**Post date:** [September 15, 2010, 1:09pm UTC](https://community.asterisk.org/t/asterisk-realtime-not-working/32568/1 "2010-09-15T13:09:52Z")

</div>

Hi,

I am trying to implement asterisk realtime so that I can store sip users in my database rather than in sip.conf.

I have installed freeTDS and unixODBC in order to connect to my MS-SQL database which all works fine. I have also made the following entry into etc/asterisk/res\_odbc.conf…

```auto
[sqlserver]
enabled => yes
dsn => MSSQLTestServer
pooling => yes
limit => 20
username => XXXX
password => XXXX
pre-connect => yes
```

By running a trace on the database I can see that a connection is made using the above login details whenever I start asterisk so I believe that asterisk itself has a succesfull connection.

I then modified /etc/asterisk/extconfig.conf so that is now looks like this:

```auto
[settings]
sipusers => odbc,sqlserver,sipusers
```

I don’t know if I have missed something out but no changes that I make to extconfig.conf seem to have any effect, even if I put complete rubbish in there it doesn’t cause any errors to be displayed either on startup or in the logs.

Any suggestion on where I am going wrong?

I am running asterisk 1.4.18.1

---

<div class="post-metadata">

**Author:** ![Raffles](https://avatars.discourse-cdn.com/v4/letter/r/f9ae1b/32.png) [@Raffles](https://community.asterisk.org/u/Raffles)\
**Post date:** [September 23, 2010, 4:16pm UTC](https://community.asterisk.org/t/asterisk-realtime-not-working/32568/2 "2010-09-23T16:16:29Z")

</div>

I think v1.4 uses the ‘old’ method for extconfig.conf

file=\> driver,database[,table] (eg. sipusers =\> odbc,database-name,sipusers)