Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #5281 > unrolled thread

Win7 64Bits SqlServer Connection

Started byPaulo Oliveira <paulo@clipinfor.com>
First post2013-05-24 09:34 -0700
Last post2013-05-29 17:42 -0400
Articles 2 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Win7 64Bits SqlServer Connection Paulo Oliveira <paulo@clipinfor.com> - 2013-05-24 09:34 -0700
    Re: Win7 64Bits SqlServer Connection "Jamal" <jamal@examples.net> - 2013-05-29 17:42 -0400

#5281 — Win7 64Bits SqlServer Connection

FromPaulo Oliveira <paulo@clipinfor.com>
Date2013-05-24 09:34 -0700
SubjectWin7 64Bits SqlServer Connection
Message-ID<3b0d2e08-59bd-4667-9d0d-e7f53a7bf319@googlegroups.com>
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

[toc] | [next] | [standalone]


#5306

From"Jamal" <jamal@examples.net>
Date2013-05-29 17:42 -0400
Message-ID<ko5soe$ku2$1@speranza.aioe.org>
In reply to#5281
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-9d0d-e7f53a7bf319@googlegroups.com...

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 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web