Use db_unixodbc modul to connect to MS SQL server. Therefore you also have to configure unixodbc.
Then, set the db_url of the other modules to the unixodbc connection. Then all the configured modules will talk to the MSSQL server instead of mysql (which is the default).
regards Klaus
On 14.11.2011 12:31, Ari Pollack wrote:
Hi Klaus, I appreciate the help but what i meant is Microsoft SQL SERVER. how can i talk to it from a linux environment. also where do i define which modules i use and how to i change the sqlops module to perform the queries? Thanks in advance, Yehuda
*From:* Klaus Darilion klaus.mailinglists@pernau.at *To:* sr-dev@lists.sip-router.org *Sent:* Monday, November 14, 2011 1:08 PM *Subject:* Re: [sr-dev] Kamailio and SQLSERVER
No need to change any code. Just use the sqlops module to perform raw SQL queries to the database.
regards klaus
On 14.11.2011 11:05, Ari Pollack wrote:
Hi All,
I am a newcomer to kamailio and would like some help. I would like to use kamailio as my sip proxy but I want to get the routing using my SQL Server stored procedures. Can anybody tell me which parts of the code I need to alter in order to do this.
Any help would be greatly appreciated, Yehuda
sr-dev mailing list sr-dev@lists.sip-router.org mailto:sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
sr-dev mailing list sr-dev@lists.sip-router.org mailto:sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev