[Freeswitch-users] ODBC error

[Archana Venugopan]

Ya it did fixed the problem. Just installed this unixodbc-devel.

Regards,
Archana.V

From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Steven Ayre
Sent: 17 December 2012 14:51
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] ODBC error

Great  :)

Did that fix the problem?

Just a thought for the core devs...
Since ODBC is now so popular perhaps rather than auto-detecting unixodbc it'd be better to have it enabled by default and give an error if it's missing?
For anyone still wanting to build without it (eg for embedded systems) add a --disable-core-odbc-support option.

-Steve


On 17 December 2012 12:32, Archana Venugopan <a.venugopan at mundio.com<mailto:a.venugopan at mundio.com>> wrote:
Thanks again. ODBC was the issue.

Regards,
Archana.V

From: freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org> [mailto:freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org>] On Behalf Of Steven Ayre
Sent: 17 December 2012 11:42
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] ODBC error

ODBC NOT AVAILABLE

This means your FS was compiled without ODBC support.

Check you have the unixodbc development package installed when building (usually unixodbc-dev or unixodbc-devel).

It should be auto-detected if installed, but to be sure run configure with the --enable-core-odbc-support to force it to look for it, that'll should then give you an error if it can't find it.



There has also been some changes to DSNs since v1.2.4 of which you should be aware.

DSNs of format "datasourcename" are no longer supported. They should be changed to one of:
"datasourcename::"
"datasourcename:username:password"
"odbc://datasourcename"
"odbc://datasourcename::"
"odbc://datasourcename:username:password"

http://wiki.freeswitch.org/wiki/DSN

I prefer using the odbc:// prefix  - it seems less likely that it would change long-term

-Steve


On 16 December 2012 20:55, Archana Venugopan <a.venugopan at mundio.com<mailto:a.venugopan at mundio.com>> wrote:
Hi,
Can anyone please tell me why I am getting this error inspite 'isql -v smepbx smepbx smeswitch' was working.


[CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx

Regards,
Archana.V


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org<mailto:consulting at freeswitch.org>
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org<mailto:consulting at freeswitch.org>
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121217/c9dfdee4/attachment-0001.html