Strange behavior from ADODB and SQL Server

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)
  • 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)
  • Re: Riding in Circles
    ... | The point is that it's done from feel and connection. ... poor eye. ... Get it consistent and reliable, then make some guesses, ... of folks who can accurately eyeball distances on this scale. ...
    (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)