MS Access (mdb) and FreeSwitch - Javascript?
Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. Thanks. Mark.
On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote:
Hello,
Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database.
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.
odbc is for all platforms including windows.
There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/ ) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng... ).
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.
Please help with any suggestions on how to do this.
Hi Mike, 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: 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"]); } I'm a hobbist not a developer so this may sound a bit dense: 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? Thanks for the help. Mark. http://wiki.freeswitch.org/wiki/ODBC -----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote: Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. odbc is for all platforms including windows. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. http://wiki.freeswitch.org/wiki/ODBC Mike = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
A quick google found me this: http://www.stylusstudio.com/configure_data_source.html The first half looks just about right for what you are looking to do. Mike On Oct 24, 2008, at 5:37 PM, mszlazak@aol.com wrote:
Hi Mike,
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:
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"]); } I'm a hobbist not a developer so this may sound a bit dense:
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?
Thanks for the help.
Mark.
http://wiki.freeswitch.org/wiki/ODBC
-----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?
On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote:
Hello,
Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database.
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.
odbc is for all platforms including windows.
There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/ ) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng... ).
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.
Please help with any suggestions on how to do this.
http://wiki.freeswitch.org/wiki/ODBC
Mike
= _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now! _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
Thank you Mike! I'll look at the linked to page next week and hopefully quickly proceed from there. Cheers. -----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 2:44 pm Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? A quick google found me this: http://www.stylusstudio.com/configure_data_source.html The first half looks just about right for what you are looking to do. Mike On Oct 24, 2008, at 5:37 PM, mszlazak@aol.com wrote: Hi Mike, 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: 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"]); } I'm a hobbist not a developer so this may sound a bit dense: 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? Thanks for the help. Mark. http://wiki.freeswitch.org/wiki/ODBC -----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote: Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. odbc is for all platforms including windows. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. http://wiki.freeswitch.org/wiki/ODBC Mike = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now! _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
http://nixbit.com/cat/database/database-engines/easysoft-odbc-odbc-bridge/th... might help too On Sat, Oct 25, 2008 at 11:00 AM, <mszlazak@aol.com> wrote:
Thank you Mike!
I'll look at the linked to page next week and hopefully quickly proceed from there.
Cheers.
-----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 2:44 pm Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?
A quick google found me this: http://www.stylusstudio.com/configure_data_source.html
The first half looks just about right for what you are looking to do.
Mike
On Oct 24, 2008, at 5:37 PM, mszlazak@aol.com wrote:
Hi Mike,
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:
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"]);
}
I'm a hobbist not a developer so this may sound a bit dense:
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?
Thanks for the help.
Mark.
http://wiki.freeswitch.org/wiki/ODBC
-----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript?
On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote:
Hello,
Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database.
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.
odbc is for all platforms including windows.
There are automatic syncs between Access and SQlite ( http://code.google.com/p/mdb-sqlite/) 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 ( http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...).
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.
Please help with any suggestions on how to do this.
http://wiki.freeswitch.org/wiki/ODBC
Mike
=
_______________________________________________
Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
------------------------------ McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now!<http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002> _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
=
_______________________________________________
Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
------------------------------ McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now!<http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002>
_______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Regards, Gayatri Kulkarni
Hi Mike, I've looked again at the ODBC page http://wiki.freeswitch.org/wiki/ODBC#ODBC_in_the_core It does into details about compiling mod_spidermonkey_odbc then editing conf/autoload_configs/spidermonkey.conf.xml http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc This describes the situation for Linux but what would I need to do if FreeSwitch is running on a Windows XP box? Thanks. -----Original Message----- From: Michael Jerris <mike@jerris.com> To: freeswitch-dev@lists.freeswitch.org Sent: Fri, 24 Oct 2008 11:44 am Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? On Oct 24, 2008, at 2:27 PM, mszlazak@aol.com wrote: Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. odbc is for all platforms including windows. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. http://wiki.freeswitch.org/wiki/ODBC Mike = _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
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? -Michael From: freeswitch-dev-bounces@lists.freeswitch.org [mailto:freeswitch-dev-bounces@lists.freeswitch.org] On Behalf Of mszlazak@aol.com Sent: Friday, October 24, 2008 12:28 PM To: freeswitch-dev@lists.freeswitch.org Subject: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. Thanks. Mark. ________________________________ McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now!<http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002>
Hi Michael. I appreciate your suggestions and will definitely consider them. Here is my background and the scenario. 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. 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. 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??? 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. Note that there can be no internet connections involved in any of this. Thanks. Mark.? ? ? ? -----Original Message----- From: Michael Giagnocavo <mgg@giagnocavo.net> To: freeswitch-dev@lists.freeswitch.org <freeswitch-dev@lists.freeswitch.org> Sent: Fri, 24 Oct 2008 12:03 pm Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? 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? ? -Michael ? From: freeswitch-dev-bounces@lists.freeswitch.org [mailto:freeswitch-dev-bounces@lists.freeswitch.org] On Behalf Of mszlazak@aol.com Sent: Friday, October 24, 2008 12:28 PM To: freeswitch-dev@lists.freeswitch.org Subject: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? ? Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. Thanks. Mark. ? McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now! _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
Well, if JavaScript is the overarching requirement, then you can probably stick to the JS version and just sort out the problems. If you're up to do Java (totally different than JS), then you can probably handle VB.NET, which will have better MS Access support in general. Finally, there is a Javascript compiler for .NET (Jscript.NET/ Jscript 8): http://msdn.microsoft.com/en-us/library/72bd815a.aspx This might give you the familiarity of Javascript, while having access to the full .NET API. So, it really depends on how comfortable you are. To any "professional" developer, I'd recommending going the .NET way, but if this is just a side thing, you gotta decide. -Michael From: freeswitch-dev-bounces@lists.freeswitch.org [mailto:freeswitch-dev-bounces@lists.freeswitch.org] On Behalf Of mszlazak@aol.com Sent: Monday, October 27, 2008 2:49 PM To: freeswitch-dev@lists.freeswitch.org Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? Hi Michael. I appreciate your suggestions and will definitely consider them. Here is my background and the scenario. 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. 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. 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??? 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. Note that there can be no internet connections involved in any of this. Thanks. Mark. -----Original Message----- From: Michael Giagnocavo <mgg@giagnocavo.net> To: freeswitch-dev@lists.freeswitch.org <freeswitch-dev@lists.freeswitch.org> Sent: Fri, 24 Oct 2008 12:03 pm Subject: Re: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? 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? -Michael From: freeswitch-dev-bounces@lists.freeswitch.org<mailto:freeswitch-dev-bounces@lists.freeswitch.org> [mailto:freeswitch-dev-bounces@lists.freeswitch.org<mailto:freeswitch-dev-bounces@lists.freeswitch.org?>] On Behalf Of mszlazak@aol.com<mailto:mszlazak@aol.com> Sent: Friday, October 24, 2008 12:28 PM To: freeswitch-dev@lists.freeswitch.org<mailto:freeswitch-dev@lists.freeswitch.org> Subject: [Freeswitch-dev] MS Access (mdb) and FreeSwitch - Javascript? Hello, Running FreeSwitch on Windows in an "low-key" "home set-up" type situation, I would like to access an MS Access database. 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. There are automatic syncs between Access and SQlite (http://code.google.com/p/mdb-sqlite/) 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 (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lng...). 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. Please help with any suggestions on how to do this. Thanks. Mark. ________________________________ McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now!<http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002> _______________________________________________ Freeswitch-dev mailing list Freeswitch-dev@lists.freeswitch.org<mailto:Freeswitch-dev@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org ________________________________ McCain or Obama? Stay updated on coverage of the Presidential race while you browse - Download Now!<http://pr.atwola.com/promoclk/100000075x1211139166x1200680084/aol?redir=http://toolbar.aol.com/elections/download.html?ncid=emlweusdown00000002>
participants (4)
-
Gayatri Kulkarni
-
Michael Giagnocavo
-
Michael Jerris
-
mszlazak＠aol.com