HOT NEWS
Remember Me
Sunday, 03 January 2010 13:43    PDF Print E-mail
5 Steps to connect Asterisk with your database server - (MS-SQL).
Article Index
5 Steps to connect Asterisk with your database server - (MS-SQL).
Step 1: Configure Linux ODBC for MS-SQL
Step 2: Create MySQL table with example data
Step 3: Configure res_odbc.conf
Step 4: Configure func_odbc.conf
Step 5: Configure extensions.conf for query
All Pages

Asterisk_To_Ms-sql

Asterisk & ODBC provide the ability to easily update and retrieve data by defining SQL statements as special variables that can be called from the dial plan.  For instance, we could bill ‘long distance’, take credit cards and let Asterisk access other types of information.  In my tutorial we will configure Asterisk to dial a variable that represents a SQL statement.  This could also be done by calling an AGI script, but why do the extra work?

 This ‘How to’ is specifically geared towards MS-SQL.  However, if you set the up the ODBC driver correctly you can use any SQL server you like.  Which leads me to my next thought, before you start, make sure ODBC is set up correctly. 



Last Updated ( Monday, 28 December 2009 14:33 )
 

Add comment


Security code
Refresh

Your are currently browsing this site with Internet Explorer 6 (IE6).

Your current web browser must be updated to version 7 of Internet Explorer (IE7) to take advantage of all of template's capabilities.

Why should I upgrade to Internet Explorer 7? Microsoft has redesigned Internet Explorer from the ground up, with better security, new capabilities, and a whole new interface. Many changes resulted from the feedback of millions of users who tested prerelease versions of the new browser. The most compelling reason to upgrade is the improved security. The Internet of today is not the Internet of five years ago. There are dangers that simply didn't exist back in 2001, when Internet Explorer 6 was released to the world. Internet Explorer 7 makes surfing the web fundamentally safer by offering greater protection against viruses, spyware, and other online risks.

Get free downloads for Internet Explorer 7, including recommended updates as they become available. To download Internet Explorer 7 in the language of your choice, please visit the Internet Explorer 7 worldwide page.