Re: General network errors running SPs via ADO

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 08:10:12 -0600

> followed by this error once:
>
> "Syntax error or access violation"

Check the executed SQL statement to see if it contains curly braces ('{',
'}'). This may be interpreted as an ODBC escape sequence, resulting in the
above error. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"John McLusky" <jmclusky@community.nospam> wrote in message 
news:uQPY%23Km7EHA.3828@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> My company has an application which runs audits overnight.  These are run 
> as stored procedures executed via ADO.  The application is written in 
> Delphi.
>
> The same stored procedure is run several times with different parameters 
> as there are several different audits run each night.
>
> Most of the SP executions work fine, and error appears on different sets 
> of parameters each time - there doesn't seem to be a particular audit that 
> causes the issue.
>
> Typically, this error will be raised twice:
>
> "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your 
> network documentation"
>
> followed by this error once:
>
> "Syntax error or access violation"
>
> The application is being run on the same machine as the SQL server itself.
>
> Any ideas?
>
> Thanks,
> John.
>
>

Relevant Pages

  • Re: General network errors running SPs via ADO
    ... Thanks Dan, will do once I'm back in the office on Tuesday (unfortunately I ... the 100 or so audits that run, it's always a different one that fails. ... >> are run as stored procedures executed via ADO. ... >> Most of the SP executions work fine, ...
    (microsoft.public.sqlserver.server)
  • Re: finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea ... what is the SQL statement that you are seeing ... cost based optimizer code. ...
    (comp.databases.oracle.server)
  • Re: Ongoing purging of active records causes deadlocks
    ... As for the clustering of the tables ... on SQL 2000 the only deadlock priorties are LOW and NORMAL. ... Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx ... We simply record lots of audits, ...
    (comp.databases.ms-sqlserver)
  • Re: Overall executions at DB level
    ... SQL> SELECT SUMFROM V$SQL ... SQL executions whatsoever in your database? ... The V$SQL view only shows the SQL statements currently in the Library Cache. ...
    (comp.databases.oracle.server)
  • Re: Moving C2 Audits
    ... C2 audits are predefined audits you can run to trace specific events on a ... SQL Server. ...
    (microsoft.public.sqlserver.security)
Loading