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.


--