Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Unanswered: MS SQL 2000 after patching with SP3

    I have patched my MS SQL 2000 DB from SP2 to SP3.

    I noticed from the enterprise manager the patch level indicates
    8.00.760 (SP3).

    However, using microsofts type 4 JDBC driver to connect to SQL2000, I got the following info when I used one of the APIs to retrieve the database version :

    Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) .

    Now.... which one is having the bug? MS JDBC driver or MS SQL 2000 SP3 ????
    Save the dugongs!

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    8.00.760 = 2000 SP3. JDBC was written before SP3.
    Look at %windir%\sqlsp.log to see SP3 is correctly installed.

  3. #3
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38
    Originally posted by ispaleny
    8.00.760 = 2000 SP3. JDBC was written before SP3.
    Look at %windir%\sqlsp.log to see SP3 is correctly installed.
    Indeed Type 4 MS JDBC driver is written b4 service pack 3.

    However, after patching MS SQL 2000, the driver should correctly retrieve the info from SQL 2000. Don't suppose that the JDBC driver has that value hard-coded in its coding?

    Probably I would temporary revert to the JDBC-ODBC bridge to do a simple check..
    Save the dugongs!

  4. #4
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Angry

    I tried to patch SP3 on MS sql 2000 standard edition, the JDBC driver reports it correctly.

    Thus, seems like the only problem occurs on my MS Sql2000 Enterprise Edition.
    Save the dugongs!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •