SQL Query Fails on NT System


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL Query Fails on NT System

  1. #1
    Ken D. Guest

    SQL Query Fails on NT System


    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
    Steve Guest

    Re: SQL Query Fails on NT System


    Would any of the values be date values? Check the default date formats between
    NT and 2000. I seem to recall that this caused a couple small differences
    between the two platforms. (I believe one used dd/mm/yy while the other used
    mm/dd/yy by default for short dates, and this was what Access/ADO/VB used
    by default for representing dates.)

    Generally if something were wrong with system files you'd be receiving errors
    rather than inaccuracies.

    Steve.

    "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
    >



  3. #3
    Joe \Nuke Me Xemu\ Foster Guest

    Re: SQL Query Fails on NT System

    "Ken D." <Kenneth.dowd@arvinmeritor.com> wrote in message <news:3d7521fe$1@10.1.10.29>...

    > 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.


    Which Jet 4.0 Service Pack is installed? When did you last compact
    the database? What are the data types of those fields?

    URL:http://support.microsoft.com/default...;en-us;Q239114

    URL:http://support.microsoft.com/default...;en-us;Q300216

    URL:http://support.microsoft.com/default...;en-us;Q273956

    --
    Joe Foster <mailto:jlfoster%40znet.com> Space Cooties! <http://www.xenu.net/>
    WARNING: I cannot be held responsible for the above They're coming to
    because my cats have apparently learned to type. take me away, ha ha!



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