edge-sql.js how to set connectionString?

Question

var edge = require('edge');

var getProduct = edge.func('sql', function () {/*
    select * from Products 
    where ProductId = @myProductId
*/});

getProduct({ myProductId: 10 }, function (error, result) {
    if (error) throw error;
    console.log(result);
});

This Code works well but I feel uncomfortable with setting the ConnectionString as ENVIROMENT_VARIALBE!

set EDGE_SQL_CONNECTION_STRING=Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True

But I can´t find a different way to do this! Even on GitHub I can´t find another way on how to set ConnectionString! So I wonder is it even possible in OOB edge-sql.js to set the ConnectionString in Code?

makim · Accepted Answer · 2013-09-17 08:15:44Z

7

After looking at the SourceCode of edge-sql, I was able to find out how it works, I wonder why on GitHub it is described with an EnviromentVariable?

Anyway here is the Code to set the ConnectionString in node.js :-)

var edge = require('edge');

var params = {
    connectionString: "Data Source=localhost;Initial Catalog=ITSM_604;Integrated Security=True",
    source: "select top 1 last_name from account_contact"
};

var getContacts = edge.func('sql', params);

getContacts(null, function(error, result){
    if (error) throw error;
    console.log(result);
});

edited Sep 17, 2013 at 8:15

answered Sep 17, 2013 at 7:39

makim

3,2944 gold badges32 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Developer Marius Žilėnas Over a year ago

Ok, guys. You want to connect to SQL Server (in my case 2005) with integrated security? Use connectionString: "Data source=<sqlserver>;Integrated security=true" replace <sqlserver> with the host of your sql server in my case it's some pc on the network.

Paul Sturm · Accepted Answer · 2013-11-03 05:55:50Z

3

Evidently (https://github.com/tjanczuk/edge/issues/65), you can do it inline too:

var mySelect = edge.func('sql', {
    source: function () {/*
        select * from Product
    */},
    connectionString: 'your connection string goes here'
});

I don't like the environmental variable technique either.

edited Nov 3, 2013 at 5:55

answered Nov 3, 2013 at 3:51

Paul Sturm

2,1682 gold badges18 silver badges23 bronze badges

Collectives™ on Stack Overflow

edge-sql.js how to set connectionString?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related