Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Win7 64Bits SqlServer Connection
77 views
Skip to first unread message
Paulo Oliveira
May 24, 2013, 12:34:56 PM5/24/13
to
Hi all,
I have a strange problem on machines with windows 7 64bit, when I run several queries my program crashes and the machine loses network connections this only happens in the sqlserver server in sbs2011. I use adoserver.
Please some help.
TIA
Paulo Oliveira
I have a strange problem on machines with windows 7 64bit, when I run several queries my program crashes and the machine loses network connections this only happens in the sqlserver server in sbs2011. I use adoserver.
Please some help.
TIA
Paulo Oliveira
Jamal
May 29, 2013, 5:42:42 PM5/29/13
to
Hi Paulo,
You need to look at your connection string.
If you are running multiple queries, you may need to add
MultipleActiveResultSets=true;
to the connection string.
Now it is possible to use a single opened connection for more than one
query.
HTH,
Jamal
"Paulo Oliveira" wrote in message
news:3b0d2e08-59bd-4667...@googlegroups.com...
You need to look at your connection string.
If you are running multiple queries, you may need to add
MultipleActiveResultSets=true;
to the connection string.
Now it is possible to use a single opened connection for more than one
query.
HTH,
Jamal
"Paulo Oliveira" wrote in message
news:3b0d2e08-59bd-4667...@googlegroups.com...
0 new messages