EXCEPTION_ACCESS_VIOLATION

From: Wolf Ganerman (anonymous_at_devdex.com)
Date: 06/27/03 

Date: Thu, 26 Jun 2003 17:59:22 -0700

Hello, I'm getting an EXCEPTION_ACCESS_VIOLATION Error when trying to
update a remote table from a web application. The same update query when
run from query analyser it works fine. But executing both a proc and
inline query from a c# sharp code results in the
EXCEPTION_ACCESS_VIOLATION error. The only time the query works from the
application is when I point the query to update a local table instead of
the remote one. The connection from the application is made using
ADO.NET. Can someone please help me. Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Heterogeneous queries error
    ... You need to set ANSI_NULLS when you *create* the proc, ... I've a dynamic query that works on linked server but it keep giving me this ... DECLARE @sqlString NVARCHAR ... -- exist in remote but missing in HQ ...
    (microsoft.public.sqlserver.programming)
  • Re: Query In BE database
    ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ... queries and that is remote queries. ...
    (microsoft.public.access.queries)
  • Re: Strange perf.
    ... HASH JOIN 72 6 K 132 ... REMOTE 30 K 2 M 72 CBDSRV_SRVCNS.WORLD SERIAL ... In the quick query the join is a hash join, ... will be executing about 30,000 queries ...
    (comp.databases.oracle.server)
  • Re: Strange perf.
    ... HASH JOIN 72 6 K 132 ... REMOTE 30 K 2 M 72 CBDSRV_SRVCNS.WORLD SERIAL ... In the quick query the join is a hash join, ... will be executing about 30,000 queries ...
    (comp.databases.oracle.server)
  • Re: Heterogeneous queries error
    ... > So where do I set the ANSI NULLS? ... You can create your stored procedure from Query Analyzer to set the options ... >> You need to set ANSI_NULLS when you *create* the proc, ... >> -- exist in remote but missing in HQ ...
    (microsoft.public.sqlserver.programming)