Why are the ODBC queries from my desktop is blocked by the sql server after running several queries in rapid succession? -

-

i create queries using visual foxpro 9.0 desktop computer ms sql server 2005 running on windows enterprise server (2003). queries repetitive , sometimes, 1 session query sql server 200,000 times in rapid succession. first few days, program running fairy sql server refusing process queries.

on checking logs in sql server, found out spid killing query process:

process id 71 killed hostname sqlserver, host process id xxxx.

i confused because hostname not sql server querying sql server.

from activity monitor noticed offending process id has following information:

62   no   sa   master   sleeping    0   awaiting command   sql agent - generic refresher ..

the details shows message:

set no_browsetable on

lastly, thinking may problem visual foxpro, tried running queries desktop machine within sql server management studio, still encountered same problem when tried queries sql server:

a transport-level error has occurred when sending request server. (provider: tcp provider, error: 0 - existing connection forcibly closed remote host.)

it's mind boggling because able establish connections queries refused server. again, thinking desktop problem, tried running queries computer. running @ first same problems occurred. these 2 desktops refused server.

i thinking might security don't know how resolve problem.

we tried restore our database backups host, same scenario happened... fine @ first problem appeared after few query sessions.

the following odbc sql server drivers:

  • microsoft ole db provider sql server
  • sql server native client 10.0
  • sql server native client 11.0

i have search web possible solution , tried suggested solutions, spid blocking, chimney offloading, rss, among others no avail. please, in need expert advise!

thank in advance.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more