Thank you Mike! I'll look at the linked to page next week and hopefully quickly proceed from there.
Cheers. -----Original Message----- From: Michael Jerris <[EMAIL PROTECTED]> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 2:44 pm Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? A quick google found me this: http://www.stylusstudio.com/configure_data_source.html The first half looks just about right for what you are looking to do. Mike On Oct 24, 2008, at 5:37 PM, [EMAIL PROTECTED] wrote: Hi Mike, I check some of it out but couldn't find anything specifically on MS Access and the ODBC driver that FreeSwitch uses. There is this example: use("ODBC"); var db = new ODBC("dsnName", "username", "password"); var sql = "select * from users"; db.connect(); if (!db.query(sql)) session.hangup(); //might want to say something nice instead. while (db.nextRow()) { row = db.getData(); console_log("debug", "UserName: " + row["user_name"]); } I'm a hobbist not a developer so this may sound a bit dense: In the above example, the var db is set up with some "dsnName". Is there somewhere in the pages / files you kindly directed me to which gives the DSN name for MS Access that I need to use with this FreeSwitch ODBC? Thanks for the help. Mark. http://wiki.freeswitch.org/wiki/ODBC -----Original Message----- From: Michael Jerris <[EMAIL PROTECTED]> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? On Oct 24, 2008, at 2:27 PM, [EMAIL PROTECTED] wrote: Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. As I understand it so far, FreeSwitch can connect to it's sqlite db and has an ODBC driver for Unix/Linux based db's but my use needs a way to connect Access. odbc is for all platforms including windows. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) that maybe a solution. Maybe I could use FreeSwitch's Javascript with Java (eg. liveconnect) and JDBS to get at MS Access, or maybe just use FreeSwitches Java and JDBS to connect to Access (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2). Frankly, I don't know which way would be best and there probably are better ways to read and/or write to MS Access from FreeSwitch. Please help with any suggestions on how to do this. http://wiki.freeswitch.org/wiki/ODBC Mike = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now! _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
_______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
