Connection Object

[jguerin]

Currently, we use the the ODBC connection string to set up a connection:

var conn_str = "Driver={SQL Server Native Client 11.0};Server=(local);Database=AdventureWorks2012;Trusted_Connection={Yes}";
sql.open(conn_str, function (err, conn) {});

It would be nicer if we had a more JavaScript-oriented way of doing this, such as a ConnectionOptions object, or or array.

There's discussions about this going on at:
http://news.ycombinator.com/item?id=4082761
Example from this thread:

{server: 'localhost', database: 'AdventureWorks2012', trusted: true}

[jbueza]

+1 -- Great work on this initiative!

[MRdNk]

The example:
{server: 'localhost', database: 'AdventureWorks2012', trusted: true}

makes more sense from a node.js point of view.

Though it also makes sense for .NET devs to be able to pass the same string as a connection string from the web.config -much easier to get to grips with.

Perhaps we need both.

[jguerin]

Thanks for the feedback. Our primary motivation right now is to make it easier for a Node.js developer, but we will definitely explore assisting migration from other platforms in the future.

[MRdNk]

I agree the node.js way is the way to go first.