edge-oledb

A module that enables OLE DB communications on Windows via C# System.Data.OleDb and Edge.js.

This module is very fast as it uses C# System.Data.OleDb and does not use any other external processes to run ole commands.

Example

var oledb = require('edge-oledb');

var options = {
    dsn: "Provider=vfpoledb.1; Data Source=C:/mydb/mydb.dbc; Mode=ReadWrite|Share Deny None;",
    query: "SELECT * FROM customers WHERE type = 'C'"
}

oledb(options, function(error, result){
    if (error) throw error;
    console.log(result);
});	

Inspiration

There was a need for an interface to an old system written in FoxPro, and the only available nodejs adodb/oledb modules at the time were slow/problematic/used external programs

Installation

$ npm install edge-oledb

More Info

• https://en.wikipedia.org/wiki/OLE_DB
• https://github.com/tjanczuk/edge
• https://www.connectionstrings.com/

People

Written by Brian Taber

License

MIT