[Freeswitch-users] ODBC through JS

[Jonas Gauffin]

your DSN name is "postgres" and not "PostgreSQL"

On Fri, Oct 10, 2008 at 12:34 PM, Gayatri Kulkarni
<xtpl.gayatri at gmail.com>wrote:

> 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
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081010/153e5781/attachment-0002.html