Monday, February 20, 2012

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 ??8.00.760 = 2000 SP3. JDBC was written before SP3.
Look at %windir%\sqlsp.log to see SP3 is correctly installed.|||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..|||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.

No comments:

Post a Comment