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 <[EMAIL PROTECTED]>
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, [EMAIL PROTECTED] 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&lngWId=2).
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
_______________________________________________
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
