VoIP Mailing List Archives

[wiltingtree at gmail.com]

Hi, I know there are a lot of answered questions about this already, but I think I read all of the answers and I'm still stuck.

* I'm using FreeSWITCH Version 1.0.trunk (14961).
* I installed UnixODBC
* My odbc.ini and odbcinst.ini files are in /usr/local/etc/
* I have symlinks to /usr/local/etc from /usr/etc and from /usr/local/freeswitch/etc/
* Im running freeswitch as root, and I copied odbc.ini to /root/.odbc.ini
* I have mod_spidermonkey_odbc uncommented in spidermonkey.conf.xml
* When I run "isql dbname" from the command prompt it works fine.


But when I try to run my script, I get:


2009-10-17 23:56:21.848930 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified


2009-10-17 23:56:21.848930 [ERR] mod_spidermonkey_odbc.c:245 Database is not connected!




Please help!
Thanks.

[brian at freeswitch.org]

How are you using this from your javascript code?

/b

On Oct 17, 2009, at 7:13 PM, Adam Wilt wrote:

[wiltingtree at gmail.com]

Brian,


Here's how I'm using the ODBC in my .js file:


use("ODBC");


var DSN="mydsn";
var DB_USER="myuser";
var DB_PASS="mypass";
.
.
.
var db = new ODBC(DSN, DB_USER, DB_PASS);
db.connect();
.
.
.


Thanks.




On Sat, Oct 17, 2009 at 8:56 PM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[wiltingtree at gmail.com]

So, where is FreeSWITCH looking for the odbc.ini file?  
I keep reading conflicting information, including /usr/local/freeswitch/etc/,  /usr/local/etc,  /usr/etc,  /home/username/ 




On Sat, Oct 17, 2009 at 9:11 PM, Adam Wilt <wiltingtree@gmail.com (wiltingtree@gmail.com)> wrote:

[brian at freeswitch.org]

Its in /etc/ or where ever your default is.. is FS running as root?

/b

On Oct 17, 2009, at 10:16 PM, Adam Wilt wrote:

[wiltingtree at gmail.com]

Yes, I have FreeSWITCH running as root.  So the odbc.ini file should be in /etc/ ? 
How do you set the default?


On Sat, Oct 17, 2009 at 11:26 PM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:

[wiltingtree at gmail.com]

Brian,  

Putting the odbc.ini and odbcinst.ini in /etc/ fixed the problem.  Thanks.


Thanks,
Marc



On Sat, Oct 17, 2009 at 11:26 PM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote: