[Freeswitch-users] ODBC through JS

[Gayatri Kulkarni]

either value for DSN name gives the same result :(

On Fri, Oct 10, 2008 at 4:27 PM, Jonas Gauffin <jonas.gauffin at gmail.com>wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/354a66c3/attachment-0002.html