<div> <font face="Arial, Helvetica, sans-serif">Hi Michael.<br>
I appreciate your suggestions and will definitely consider them.<br>
Here is my background and the scenario. <br>
<br>
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.<br>
<br>
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.<br>
<br>
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???<br>
<br>
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. <br>
<br>
Note that there can be no internet connections involved in any of this.<br>
<br>
Thanks.<br>
<br>
Mark. <br>
<br>
<br>
</font></div>
<div> <br>
</div>
<div> <br>
</div>
-----Original Message-----<br>
From: Michael Giagnocavo <mgg@giagnocavo.net><br>
To: freeswitch-dev@lists.freeswitch.org <freeswitch-dev@lists.freeswitch.org><br>
Sent: Fri, 24 Oct 2008 12:03 pm<br>
Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?<br>
<br>
<div id="AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad">
<style> @#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} #AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad p.MsoNormal,#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad li.MsoNormal,#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";}#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad a:link,#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad a:visited,#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;}#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad span.EmailStyle17 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;}#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad .MsoChpDefault {mso-style-type:export-only;}@#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;}#AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad div.Section1 {page:Section1;}</style>
<div class="Section1">
<div class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">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?</span></div>
<div class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></div>
<div class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">-Michael</span></div>
<div class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<div class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> <a href="mailto:freeswitch-dev-bounces@lists.freeswitch.org">freeswitch-dev-bounces@lists.freeswitch.org</a>
[<a href="mailto:freeswitch-dev-bounces@lists.freeswitch.org?">mailto:freeswitch-dev-bounces@lists.freeswitch.org</a>] <b>On Behalf Of </b><a href="mailto:mszlazak@aol.com">mszlazak@aol.com</a><br>
<b>Sent:</b> Friday, October 24, 2008 12:28 PM<br>
<b>To:</b> <a href="mailto:freeswitch-dev@lists.freeswitch.org">freeswitch-dev@lists.freeswitch.org</a><br>
<b>Subject:</b> [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?</span></div>
</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal"><span style="font-family: "Arial","sans-serif";">Hello,<br>
<br>
Running FreeSwitch on Windows in an "low-key" "home set-up"
type situation, I would like to access an MS Access database. <br>
<br>
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.
<br>
<br>
There are automatic syncs between Access and SQlite
(<a href="http://code.google.com/p/mdb-sqlite/" target="_blank">http://code.google.com/p/mdb-sqlite/</a>) 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
(<a href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2" target="_blank">http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2</a>).
<br>
<br>
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. <br>
<br>
Please help with any suggestions on how to do this. <br>
<br>
Thanks.<br>
<br>
Mark.</span></div>
<div id="MAILCIADB031-90b3490213ae68">
<div class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;"> </span></div>
<div class="MsoNormal" style="margin-top: 7.5pt; text-align: center;" align="center"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;">
<hr align="center" size="2" width="100%">
</span></div>
<div class="MsoNormal" style="margin-top: 7.5pt;"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;">McCain or Obama? Stay updated on
coverage of the Presidential race while you browse - <a target="_blank" href="http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002">Download
Now!</a></span> </div>
</div>
</div>
</div>
<!-- end of AOLMsgPart_3_d4c87a44-49f3-4114-b047-fdb84e824dad -->
<div id="AOLMsgPart_4_d4c87a44-49f3-4114-b047-fdb84e824dad" style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<pre style="font-size: 9pt;"><tt>_______________________________________________<br>
Freeswitch-dev mailing list<br>
<a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</tt></pre>
</div>
<!-- end of AOLMsgPart_4_d4c87a44-49f3-4114-b047-fdb84e824dad -->
<div id='MAILCIAMB046-92c1490629313cb' class='aol_ad_footer'><BR/><FONT style="color: black; font: normal 10pt ARIAL, SAN-SERIF;"><HR style="MARGIN-TOP: 10px"></HR>McCain or Obama? Stay updated on coverage of the Presidential race while you browse - <a href="http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002">Download Now!</a></FONT> </div>