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@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@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
-- Regards, Gayatri Kulkarni