<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">A quick google found me this:<div><br></div><div><a 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="padding-top: 1em; padding-right: 1em; padding-bottom: 1em; padding-left: 1em; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: dashed; border-right-style: dashed; border-bottom-style: dashed; border-left-style: dashed; border-top-color: rgb(47, 111, 171); border-right-color: rgb(47, 111, 171); border-bottom-color: rgb(47, 111, 171); border-left-color: rgb(47, 111, 171); color: black; background-color: rgb(249, 249, 249); line-height: 1.1em; ">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"]);
}</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 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> <!-- end of AOLMsgPart_3_e37d6c28-0f0d-4b86-8868-eb42da7a26c9 --> <div id="AOLMsgPart_4_e37d6c28-0f0d-4b86-8868-eb42da7a26c9" style="margin: 0px;font-family: Tahoma, Verdana, Arial, Sans-Serif;font-size: 12px;color: #000;background-color: #fff;"> <pre style="font-size: 9pt;"><tt>_______________________________________________
Freeswitch-dev mailing list
<a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</tt></pre> </div> <!-- end of AOLMsgPart_4_e37d6c28-0f0d-4b86-8868-eb42da7a26c9 --> <div id="MAILCIAMB042-92bd4902401944" class="aol_ad_footer"><br><font style="color: black; font: normal 10pt ARIAL, SAN-SERIF;"><hr style="MARGIN-TOP: 10px">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> _______________________________________________<br>Freeswitch-dev mailing list<br><a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a><br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev<br>http://www.freeswitch.org<br></blockquote></div><br></div></body></html>