[Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?

[mszlazak at aol.com]

 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 <mike at jerris.com>
To: freeswitch-dev at 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, mszlazak at aol.com 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 <mike at jerris.com>
 To: freeswitch-dev at 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, mszlazak at aol.com 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 at 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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev
http://www.freeswitch.org



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20081025/1372f7b7/attachment.html