From the unixODBC error it's interpreting this as a ODBC DSN. The reason is the sqlite prefix is sqlite:// not core:// (see http://wiki.freeswitch.org/wiki/DSN). You also don't have enough slashes.

Try:

local dbh = freeswitch.Dbh("sqlite:///usr/local/temp/database.db");

(note the 3 slashes - :// is standard URI format, the 3rd indicates an absolute path).

-Steve

On 5 February 2013 08:56, Carlo Dimaggio <jaasmailing@gmail.com> wrote:

Hi all!

I have a lua script in which i have a statement that connects to a sqlite db:

local dbh = freeswitch.Dbh("core:/usr/local/temp/database.db");

but i receve in FS CLI this error that refers to a Pgsql instead of sqlite:

2013-02-05 09:40:10.379612 [ERR] switch_odbc.c:365 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2013-02-05 09:40:10.379612 [CRIT] switch_core_sqldb.c:504 Failure to connect to PGSQL core!
2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:354 Connection failed. DBH NOT Connected.
2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:435 DBH NOT Connected.

Can you help me?

Best regards,

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

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

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org