msmq missing messages after applying SP3a to SQL server

Used to work fine:
(windows 200 server, sql server 2000, JDBC driver SP2.)
Two java processes, one sending messages (using jdbc and sql as temp storage), second is receiving and placing on msmq.

After installing SP3a for SQL server, under high load (200 a sec) there are missing messages in msmq.
Installed everything from scratch on separate machine, works fine until SP3a is applied.
Any help is highly appreciatedCheck for error messages on the box with SP3. M$ closed the hole for buffer overflow. JDBC by default is declaring @.Px as NVARCHAR(4000). If you are not handling TYPEing correctly, post-SP3 machine will post something like "Invalid TDS packet sent by client" error to the log.|||That would be where I look first. With sp3/3a microsoft modified quite a bit on the security side which has caused problems in other areas as well. Check your event logs and sql server logs. If nothing there, use sql profiler on the test machine and trap on "errors and warnings".|||actually, i belive it was a good thing they addressed this, but a bad thing the way they did it. now the bewildered and confused jdbc coders are looking out the window and wondering if the world's really ending or it's just their code...

MSI installer error with SQL Server JDBC Driver SP2

Hi,
I keep getting an MSI installer error when trying to install JDBC driver SP2
for SQL Server 2000. I keeps asking for a ... service pack 2.msi file?
I am working on Windows 2003 Server Enterprise Edition. The previous version
works fine.
Any help would be great.
Thanks
Lee
| Thread-Topic: MSI installer error with SQL Server JDBC Driver SP2
| thread-index: AcUDDSfKiFlzBui6QyGvogqFUQxBrQ==
| X-WBNR-Posting-Host: 143.41.8.10
| From: =?Utf-8?B?TGVl?= <Lee@.discussions.microsoft.com>
| Subject: MSI installer error with SQL Server JDBC Driver SP2
| Date: Tue, 25 Jan 2005 10:39:08 -0800
| Lines: 14
| Message-ID: <163DBEE7-93F1-41CA-864C-25BF166267BC@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6611
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi,
|
| I keep getting an MSI installer error when trying to install JDBC driver
SP2
| for SQL Server 2000. I keeps asking for a ... service pack 2.msi file?
|
| I am working on Windows 2003 Server Enterprise Edition. The previous
version
| works fine.
|
| Any help would be great.
|
| Thanks
|
| Lee
|
|
Hi Lee,
I'm not sure what is wrong with the MSI package, but you really should
consider using JDBC SP3, not SP2.
SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/d...B11-0502-461A-
B138-2AA54BFDC03A&displaylang=en
If you receive the same error while trying to install JDBC SP3, please post
the error.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.