DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Query Failing

  1. #1
    Ken D. Guest

    SQL Query Failing


    I have developed a database application in VB6 that is using ADO 2.5 to connect
    to an Access 2000 database (Jet 4.0). The application is running fine off
    of Windows 2000 systems; however, I've run into problems when running the
    app off of Windows NT. When a SQL query is run, the recordset does not return
    all of the records. The SQL is as follows:

    SELECT qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, Sum(qryMatch_All_REVISED.Variance)
    AS SumOfVariance, qryMatch_All_REVISED.Period
    From qryMatch_All_REVISED
    GROUP BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, qryMatch_All_Revised.Period

    Having (((qryMatch_All_REVISED.Period) = varPeriod
    ORDER BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt

    The SQL is running off of a union query stored in the Jet db.

    We reinstalled MDAC 2.7 with all of the patches on the NT system, but still
    are not getting the correct results.

    Are some significant differences between Windows 2000 and NT that I am missing?
    Maybe my setup file is missing a DLL or 2 that is on the Windows 2000 machines
    but no the NT machine? Any advice or ideas would be greatly apperciated.
    Thank you.

    Ken





  2. #2
    Bernie Guest

    Re: SQL Query Failing


    "Ken D." <kenneth.dowd@arvinmeritor.com> wrote:
    >
    >I have developed a database application in VB6 that is using ADO 2.5 to

    connect
    >to an Access 2000 database (Jet 4.0). The application is running fine off
    >of Windows 2000 systems; however, I've run into problems when running the
    >app off of Windows NT. When a SQL query is run, the recordset does not

    return
    >all of the records. The SQL is as follows:
    >
    >SELECT qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, Sum(qryMatch_All_REVISED.Variance)
    >AS SumOfVariance, qryMatch_All_REVISED.Period
    >From qryMatch_All_REVISED
    >GROUP BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt, qryMatch_All_Revised.Period
    >
    >Having (((qryMatch_All_REVISED.Period) = varPeriod
    >ORDER BY qryMatch_All_REVISED.txtBU, qryMatch_All_REVISED.Name_Rpt
    >
    >The SQL is running off of a union query stored in the Jet db.
    >
    >We reinstalled MDAC 2.7 with all of the patches on the NT system, but still
    >are not getting the correct results.
    >
    >Are some significant differences between Windows 2000 and NT that I am missing?
    > Maybe my setup file is missing a DLL or 2 that is on the Windows 2000 machines
    >but no the NT machine? Any advice or ideas would be greatly apperciated.
    > Thank you.
    >
    >Ken
    >

    Hi Ken,

    Before doing anything else, try to enclose all fieldnames with square brackets
    like [qryMatch_All_REVISED].[txtBU]

    I have found out that some names seem to be restricted, e.g. authority, password
    and some more. But it seems to be inconsistent between OS versions...

    Bernie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center