[Freeswitch-users] Not able to connect mysql using Dbh

[ovvenkat]

Hi to all,
I could not able to connect to mySql using Dbh. Here is the coding I have
used to connect to my db.
*
local dbh = assert(freeswitch.Dbh("dsn_name","venkat","venkat123"))*

I am getting following error while executing the lua test.lua in fs_cli

2010-09-29 17:57:29.924498 [ERR] mod_lua.cpp:182
/usr/local/freeswitch/scripts/test.lua:23: attempt to call field 'Dbh' (a
nil value)
stack traceback: /usr/local/freeswitch/scripts/test.lua:23: in main chunk

*/etc/odbc.ini* file contains

[dsn_name]
Driver=MySQL
SERVER=localhost
PORT=3306
USER=venkat
PASSWORD=venkat123
DATABASE=venkat
Socket = /var/lib/mysql/mysql.sock

*I can able to connect to my db using following command *

isql dsn_name venkat venkat123

I trying to figure it out for past two days and gone though wiki  not able
to crack it. Any one please help me to resolve my issue.


-- 

Regards
Venkatesan OV.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100930/8b9f66e9/attachment-0001.html