<a href="http://nixbit.com/cat/database/database-engines/easysoft-odbc-odbc-bridge/">http://nixbit.com/cat/database/database-engines/easysoft-odbc-odbc-bridge/</a> this might help too<br><br><div class="gmail_quote">On Sat, Oct 25, 2008 at 11:00 AM, <span dir="ltr"><<a href="mailto:mszlazak@aol.com">mszlazak@aol.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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 class="Ih2E3d">
<div> <br>
</div>
<div> <br>
</div>
-----Original Message-----<br>
From: Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>><br>
To: <a href="mailto:freeswitch-dev@lists.freeswitch.org" target="_blank">freeswitch-dev@lists.freeswitch.org</a><br></div><div><div></div><div class="Wj3C7c">
Sent: Fri, 24 Oct 2008 2:44 pm<br>
Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?<br>
<br>
<div>
A quick google found me this:
<div><br>
</div>
<div><a href="http://www.stylusstudio.com/configure_data_source.html" target="_blank">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" target="_blank">mszlazak@aol.com</a> wrote:</div>
<br><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 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 href="http://wiki.freeswitch.org/wiki/ODBC" target="_blank">http://wiki.freeswitch.org/wiki/ODBC</a></blockquote><br>
<br>
<br>
-----Original Message-----<br>
From: Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>><br>
To: <a href="mailto:freeswitch-dev@lists.freeswitch.org" target="_blank">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> <br>
<div>
<div>On Oct 24, 2008, at 2:27 PM, <a href="mailto:mszlazak@aol.com" target="_blank">mszlazak@aol.com</a> wrote:</div>
<br><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 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>
</font></blockquote><br>
</div>
<div><a href="http://wiki.freeswitch.org/wiki/ODBC" target="_blank">http://wiki.freeswitch.org/wiki/ODBC</a></div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
= </div>
<div 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" target="_blank">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>
<div><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;"><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" target="_blank">Download Now!</a></font> </div>
_______________________________________________<br>
Freeswitch-dev mailing list<br>
<a href="mailto:Freeswitch-dev@lists.freeswitch.org" target="_blank">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>
<div 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" target="_blank">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>
<div><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;"><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" target="_blank">Download Now!</a></font> </div>
</div></div><br>_______________________________________________<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>
<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Gayatri Kulkarni<br>