<div> <font face="Arial, Helvetica, sans-serif">Thank you Mike! <br>
<br>
I'll look at the linked to page next week and hopefully quickly proceed from there.<br>
<br>
Cheers.<br>
</font></div>
<div> <br>
</div>
<div> <br>
</div>
-----Original Message-----<br>
From: Michael Jerris <mike@jerris.com><br>
To: freeswitch-dev@lists.freeswitch.org<br>
Sent: Fri, 24 Oct 2008 2:44 pm<br>
Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?<br>
<br>
<div id="AOLMsgPart_3_4e185966-c25a-4d99-9375-9434fbc80d89">
A quick google found me this:
<div><br>
</div>
<div><a target="_blank" href="http://www.stylusstudio.com/configure_data_source.html">http://www.stylusstudio.com/configure_data_source.html</a></div>
<div><br>
</div>
<div>The first half looks just about right for what you are looking to do.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
<div>
<div>On Oct 24, 2008, at 5:37 PM, <a href="mailto:mszlazak@aol.com">mszlazak@aol.com</a> wrote:</div>
<br class="Apple-interchange-newline"><blockquote type="cite">
<div><br>
</div>
<div>Hi Mike,</div>
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div><span class="Apple-style-span" style="font-family: -webkit-sans-serif; line-height: 19px;"><pre style="border: 1px dashed rgb(47, 111, 171); padding: 1em; color: black; background-color: rgb(249, 249, 249); line-height: 1.1em;">use("ODBC");<br>
<br>
var db = new ODBC("dsnName", "username", "password");<br>
var sql = "select * from users";<br>
<br>
db.connect();<br>
<br>
if (!db.query(sql))<br>
session.hangup(); //might want to say something nice instead.<br>
<br>
while (db.nextRow())<br>
{<br>
row = db.getData();<br>
console_log("debug", "UserName: " + row["user_name"]);<br>
}</pre></span></div>
<div>I'm a hobbist not a developer so this may sound a bit dense:</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Thanks for the help.</div>
<div><br>
</div>
<div>Mark.</div>
<br>
<blockquote style="border-left: 2px solid blue; padding-left: 3px;"><a target="_blank" href="http://wiki.freeswitch.org/wiki/ODBC">http://wiki.freeswitch.org/wiki/ODBC</a></blockquote><br>
<br>
<br>
-----Original Message-----<br>
From: Michael Jerris <<a href="mailto:mike@jerris.com">mike@jerris.com</a>><br>
To: <a href="mailto:freeswitch-dev@lists.freeswitch.org">freeswitch-dev@lists.freeswitch.org</a><br>
Sent: Fri, 24 Oct 2008 11:44 am<br>
Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?<br>
<br>
<div id="AOLMsgPart_3_e37d6c28-0f0d-4b86-8868-eb42da7a26c9"> <br>
<div>
<div>On Oct 24, 2008, at 2:27 PM, <a href="mailto:mszlazak@aol.com">mszlazak@aol.com</a> wrote:</div>
<br class="Apple-interchange-newline"><blockquote type="cite"><font face="Arial, Helvetica, 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. </font></blockquote>
<div><br>
</div>
odbc is for all platforms including windows.</div>
<div><br>
</div>
<div><blockquote type="cite"><font face="Arial, Helvetica, sans-serif"> There are automatic syncs between Access and SQlite (<a target="_blank" href="http://code.google.com/p/mdb-sqlite/">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 target="_blank" href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2">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>
</font></blockquote><br>
</div>
<div><a target="_blank" href="http://wiki.freeswitch.org/wiki/ODBC">http://wiki.freeswitch.org/wiki/ODBC</a></div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
= </div>
<div id="AOLMsgPart_4_e37d6c28-0f0d-4b86-8868-eb42da7a26c9" 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 target="_blank" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a><br>
UNSUBSCRIBE:<a target="_blank" href="http://lists.freeswitch.org/mailman/options/freeswitch-dev">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a><br>
<a target="_blank" href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
</tt></pre> </div>
<div id="MAILCIAMB042-92bd4902401944" class="aol_ad_footer"><br>
<font style="color: black; font-family: ARIAL,SAN-SERIF; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;"><hr style="margin-top: 10px;">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></font> </div>
_______________________________________________<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>
</blockquote></div>
<br>
</div>
=
</div>
<!-- end of AOLMsgPart_3_4e185966-c25a-4d99-9375-9434fbc80d89 -->
<div id="AOLMsgPart_4_4e185966-c25a-4d99-9375-9434fbc80d89" 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_4e185966-c25a-4d99-9375-9434fbc80d89 -->
<div id='MAILCIAMB046-92c14902af09368' 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>