node-tds icon indicating copy to clipboard operation
node-tds copied to clipboard

sql server instance support? host paramter support (local)?

Open jiangjianxiao opened this issue 13 years ago • 3 comments

host:"(local)" -> ENOTFOUND host:"localhost\sqlexpress" -> ENOTFOUND

jiangjianxiao avatar Jan 09 '12 09:01 jiangjianxiao

The host should support "localhost" or "127.0.0.1". This is literally the host used in the socket: https://github.com/cretz/node-tds/blob/master/src/tds-client.coffee#L42. There are some undocumented connections options you can provide such as instanceName which will choose the instance (actually sent as part of a TDS prelogin packet)

I will leave this issue open until I document some of those other connection options.

cretz avatar Jan 09 '12 18:01 cretz

@cretz Is instanceName one of the Connection option keys available in 0.1.0?

jonbuffington avatar Jan 18 '12 14:01 jonbuffington

Yes, it should be, but just not documented. I have not yet tested its functionality.

cretz avatar Jan 18 '12 17:01 cretz