I have been developing a node app that connects to a SQL Server database 
using mssql but I have run into a wall. Basically, mssql seems to have some 
kind of bug where it simply crashes the app if the results of a query of 
any kind returns a decent number of records. Nothing too heavy. I'm talking 
about 50 to 100 records!

The queries run fine if I limit them to return 10, 20, 40 records, but as 
soon as the resultset is larger than a certain number of records (it varies 
from query to query), the app simply crashes without a single error 
message. No exceptions. Nothing.

This is a show-stopper for me. It happens on all queries I have tried, on 
different tables, different databases. The results are always the same. It 
runs fine when the query returns just a few records (5, 10, 20, for 
example) but after gradually increasing the limit of records (using "SELECT 
TOP x ...") there comes a point in which the app just crashes. No error 
messages, no exception, nothing. The number at which the app crashes varies 
between the different queries but the behaviour is the same always.

Am I missing something? Is there I setting I should tweak to avoid this?

Alternatively, is there any other npm that I could use to connect to SQL 
Server?

Thank you!

-- 
Job board: http://jobs.nodejs.org/
New group rules: 
https://gist.github.com/othiym23/9886289#file-moderation-policy-md
Old group rules: 
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
--- 
You received this message because you are subscribed to the Google Groups 
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/nodejs/2425434e-8ccf-489f-a6bc-a80076c71cf9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to