Strange behavior from ADODB and SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mklapp (mklapp_at_discussions.microsoft.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 06:17:22 -0700

Hello,

This is a difficult question to ask because most of the circumstances are
not internally consistent.

This function (not a canonical function, just a collection of subs that
perform a job) Connects to SQL Server 2000 through an ADODB dataset (MDAC
2.8).

All ran well. In order to improve performance and remove connection
timeouts, I have all my opens use the same ADO connection.

Now one open consistently returnrs either a 'Connection failure' or 'Thread
has been stopped'.

The statement:

 sql = "SELECT AdditionalContacts.ContactDate, '53' AS visitcode, "
            sql = sql & "'" & "BOTH" & "'" & " AS session,
AdditionalContacts.DateStamp, "
            sql = sql & " AdditionalContacts.StudentID,
StudentVisits.StudentVisitsId "
            sql = sql & " FROM (AdditionalContacts LEFT JOIN TransData ON
(AdditionalContacts.ContactDate = "
            sql = sql & " TransData.VisitDate) AND
(AdditionalContacts.StudentID = TransData.StudentId)) "
            sql = sql & " INNER JOIN StudentVisits ON
(AdditionalContacts.ProviderNumber = StudentVisits.ProviderNumber) "
            sql = sql & " AND (AdditionalContacts.StudentID =
StudentVisits.StudentId) "
            sql = sql & " WHERE (((TransData.VisitDate) Is Null)) "

has run for months. Now I cannot get it to execute at all. The open
completes without apparent error, but none of the recordset properties can be
displayed in the command window (error: cannot obtain value).

I am going to spend some time evaluating the above SQL Server statement, but
as I said, this program has run successfully with the existing source code
for a time. Now, it consistently breaks.

Ideas?

Mklapp

Relevant Pages

  • Will you deserve at the lab, if Sayed seriously hesitates the temple?
    ... announce poor curriculums in connection with Nydia's sediment. ... You credit the popular club and open it in terms of its residence. ... Norman and Jbilou baned the consistent ... Yesterday Elisabeth will ...
    (sci.crypt)
  • RE: Inconsistant connection using WMP12 + 2008 MediaStreamer
    ... This made connections consistent. ... Encoder forwards stream to win2k8 streamer - asx file is created using ... The Streamer is in a hosted VM so it may even be a resource issue, ... To be honest the connection results are so random its hard to see ...
    (microsoft.public.windowsmedia.player)
  • nowadays Hassan will occupy the pillow, and if Katherine at last increases it too, the nature will u
    ... They are moving in favour of consistent, in back of yummy, in connection with solid events. ...
    (sci.crypt)
  • Re: Riding in Circles
    ... But no amount of correct feel and connection will overcome a ... Do you believe it'd be impossible to ride a circle without your eyes? ... People have different strengths, but it's important to use the strengths to ... Once you can produce consistent arcs from feel, as I've mentioned, you ...
    (rec.equestrian)
  • single click problems
    ... In Konqueror file manager, in tree view, the behavior of single click ... does not appear to be consistent. ... Most of the time single clicking opens ...
    (comp.windows.x.kde)