[Freeswitch-users] ODBC through JS

[Gayatri Kulkarni]

latest version of odbc.ini:

[ODBC Data Sources]
PostgreSQL              = PostgreSQL Database Driver

[PostgreSQL]
Description             = PostgreSQL Database Driver
Driver          = /usr/local/lib/libodbcpsql.so
Trace           = Yes
TraceFile               = sql.log
Database                = postgres
Servername              = 58.68.117.43
UserName                = <username>
Password                = <password>
Port            = 5432
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables                = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =

[Default]
Driver          = /usr/local/lib/libodbcpsql.so

[ODBC]
Trace           = 1
TraceFile               = /var/log/odbctrace.out
Driver          = /usr/local/lib/libodbcpsql.so


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

> 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
>



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