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

[mszlazak at aol.com]

 Hi Michael.
I appreciate your suggestions and will definitely consider them.
Here is my background and the scenario. 

One amateur/hobby programmer (me) that has not programmed in anything but JavaScript for a long, long time but does have spare time to try (re)learning a few things to do this project better.

The project itself does not have to be to the standards of a professional developers polished masterpiece, it can be cobbled together and just needs to work well enough to be tested in the field. Refinements can be done later by pros if that is needed.

The FreeSwitch application must run in Windows on a machine where other windowed applications (e.g. www.scheduleview.com, custom MS Access calendar/scheduler templates, etc) will be running at the same time. Call volumes are very small (maybe 3 at once but usually 1 or 2) and the windowed applications don't run often (i.e. think of a receptionist scheduling an appointment for a patient with a doctor in a private practice using a software appointment calendar). Freeswitch will be connected to a regular phone line and it's speech recognition engine will be used to have client automatically "self-schedule" an appointment. I'm only using FreeSwitch because when I started looking a LumenVox's speech recognition engine, the LumenVox people said I needed to connect all this up with Asterisk. However, Asterisk won't do since it's Linux only and I do not want a seperate telephony server talking to a Windows box. FreeSwitch seemed like a better choice since it's available as a native Windows application and actually uses the same speech engine that LumenVox uses from Carnagie-Mellon. Maybe FreeSwitch is over kill to connect the things I want???

MS Access (mdb) databases are used by say www.scheduleview.com which gives me a good GUI interface or I might need to make up some MS Access application to do this. VB programming may then be needed but I would like to get around this with things I'm more familiar with like JavaScript (or even stretching a bit on my part by possibly using Java) and using the browser with an offline webpage. 

Note that there can be no internet connections involved in any of this.

Thanks.

Mark.? ? ? 

?


 


 

-----Original Message-----
From: Michael Giagnocavo <mgg at giagnocavo.net>
To: freeswitch-dev at lists.freeswitch.org <freeswitch-dev at lists.freeswitch.org>
Sent: Fri, 24 Oct 2008 12:03 pm
Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?

























Why not use mod_managed, and write in VB, F# or C#? Then you can
use System.Data and the native OleDb for Access. What is your scenario?



?



-Michael



?






From: freeswitch-dev-bounces at lists.freeswitch.org
[mailto:freeswitch-dev-bounces at lists.freeswitch.org] On Behalf Of mszlazak at aol.com

Sent: Friday, October 24, 2008 12:28 PM

To: freeswitch-dev at lists.freeswitch.org

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






?



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.




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. 



Thanks.



Mark.






?













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/20081027/36437435/attachment.html