Connection from Windows

[rodrigomontemayor]

Not sure where to ask you this, so here it goes.

I'm using Windows trying to use node to connect to SQL Server 2008.
I can specify the IP of the server, but i don't know where to set the instance, for example in VisualStudio goes like:

".\SQLEXPRESS\databasename.dbo"

...where SQLEXPRESS is the instance name. I see there's a "database" property in the options array, but not the instance name.

You reference in your tests the file test-connection.json. ¿Could you provide an example of that file? Just to see the properties or something to specify that... I hope I explained my issue clearly.

Thank you!

[pekim]

database is what you would specify in a use statement (http://msdn.microsoft.com/en-us/library/ms188366.aspx).
You don't need to specify a database in the connection configuration, in which case you'll be connected to the server's default database.

An example test-connection.json looks like this.

{
  "server": "192.168.1.210",
  "userName": "test",
  "password": "test",
  "options": {
    "port": 1433,
    "timeout": 1000,
    "database": "test"
  }
}

I'm sorry for not providing better documentation. I'll be working on that soon.

[rodrigomontemayor]

Ohh ok perfect. In case someone asks you, I solved my issue this way:

Apart from the "default database", SQL Server handles "named instances" (each of which can have several database and a default one). For example, my installation has a default named instance of "SQLEXPRESS". Even when the port in the installation is 1433, I had to use SQL Server Conf. Manager, go to my specific named instance and check its 'TCP Dynamic Port'. Using that port (15740), I had no problem making a test insertion to the database.

Thanks a lot man, great work with this project.

[mkayad]

if you just use the 'TCP Dynamic Port' in the IPALL section, it works fine.