either value for DSN name gives the same result :(

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

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

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

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

freeswitch@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@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@gmail.com> wrote:

Guys,
I am now having this problem:
when i run my script i get this error -

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