[Freeswitch-users] ODBC through JS

[Gayatri Kulkarni]

Guys please help me on this
I am still getting that error

*freeswitch at fedora> 2008-10-07 17:27:24 [ERR] switch_odbc.c:160
switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified*

I can connect to the database successfully using isql -v command
I can't figure out whats going on
Here's my script:

use("ODBC");

var DSN="PostgreSQL";
var DB_USER="<username>";
var DB_PASS="<password>";

var db = new ODBC(DSN, DB_USER, DB_PASS);
//console_log("notice",DB.path+"\n");
if(db.connect()){
  console_log("notice","Connected to DB");
}
else{
  console_log("notice","Still probs");
}

*Here's the output:*
freeswitch at fedora> 2008-10-10 15:41:32 [ERR] switch_odbc.c:160
switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified

2008-10-10 15:41:32 [NOTICE] testdb.js:1 console_log() Still probs

Please Help me

Regards,
Gayatri Kulkarni

On Tue, Oct 7, 2008 at 5:37 PM, Gayatri Kulkarni <xtpl.gayatri at gmail.com>wrote:

> Guys,
> I am now having this problem:
> when i run my script i get this error -
>
> freeswitch at fedora> 2008-10-07 17:27:24 [ERR] switch_odbc.c:160
> switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver
> Manager]Data source name not found, and no default driver specified
>
> my .*./etc/odbc.ini* looks like this:
> [postgres]
> Driver = PostgreSQL
> SERVER = localhost
> PORT = 5432
> DATABASE = postgres
> UserName = <username>
> Password = <password>
>
> and .*./etc/odbcinst.ini:*
> [ODBC]
> Trace = yes
> TraceFile = /tmp/trace.log
>
> [PostgreSQL]
> Description     = PostgreSQL driver
> Driver          = /usr/local/lib/libodbpsql.so
> Setup           = /usr/local/lib/libodbpsqlS.so
> UsageCount      = 1000000
>
> --
> Regards,
> Gayatri Kulkarni
>
> On Tue, Oct 7, 2008 at 11:32 AM, Brian West <brian at freeswitch.org> wrote:
>
>> thats because you don't load it in modules.conf.xml you load it
>> in conf/autoload_configs/spidermonkey.conf.xml
>> /b
>>
>> On Oct 7, 2008, at 12:52 AM, Gayatri Kulkarni wrote:
>>
>> Still the same :(
>> It builds installs the shard library at {prefix}/freeswitch/lib directory
>> while all the modules .so files are in {prefix}/freeswitch/mod directory
>> If i copy the shared library to the mod directory, i get an error saying Invalid
>> ELF Header !!
>>
>> --
>> Regards,
>> Gayatri Kulkarni
>>
>>
>>
>> _______________________________________________
>> Freeswitch-users mailing list
>> 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
>>
>>
>
>
>


-- 
Regards,
Gayatri Kulkarni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081010/68624459/attachment-0002.html