<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;">http://wiki.freeswitch.org/wiki/ODBC</blockquote><br>
<br>
<br>
-----Original Message-----<br>
From: Michael Jerris <mike@jerris.com><br>
To: freeswitch-dev@lists.freeswitch.org<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"></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>