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

[Michael Jerris]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20081024/90977b53/attachment.html