Re: SQL Query results in a EAccessViolation

Somtimes I get a EAccessViolation where is this comming from? I have run at
that time this query already for the past 12 to 24 hours. from the same
location to the same server.

Do have any additional exception details, such as the faulting module? We don't really have enough information to help you. You might try posting this to a Delphi forum/group since it is more likely that AV is occurring in a layer outside of ADO (e.g. BDE).

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"JvdNiet" <JvdNiet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4F0F03B3-A848-427F-BE0F-3AF531F0AF5B@xxxxxxxxxxxxxxxx
Hi I have a query that I run every 5 seconds in a DB.

Somtimes I get a EAccessViolation where is this comming from? I have run at
that time this query already for the past 12 to 24 hours. from the same
location to the same server.

Server is 2005 Express.
Client is a ADOQuery, ADOConnection.

The Query is very flat.
SELECT COUNT(8) AS NrCritical FROM Tbl_Messages WHERE Critical =
:lCritical AND Acknowledge = :lAcknowledge;


lCritical: [True]
lAcknowledge: [False]

Regards

Jvdn


.

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... the OWC10 with 3 dimensions on the row axis, ... The largest size of any of these 4 dimensions < 360 members. ... Performance Guide to optimize the query, the cube, the server, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: freetexttable query never completes nor times out?
    ... if your server doesn't have much memory ... and the "executing query" ball just kept ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ...
    (microsoft.public.sqlserver.fulltext)