• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL7 Service Pack 3

tbrandley

Member
JDE now lists SQL Server 7 at SP3 as part of their minimum technical
requirements for OneWorld B7332 and Xe. We're currently at SQL7 SP2 with Hot
Fix 851. Technical support cannot seem to give us any compelling reasons for
upgrading our database to SP3 although we are considering doing so if for no
other reason than to ensure their continued support. Has anyone experienced
any negative/positive effects from this service pack level upgrade?

Tim Brandley
QNX Software Systems Ltd., Canada
Live: B7332 SP11.3
Testing: B7333 Xe DV7333 SP15 Update1
NT4/SQL7 SP2 with HotFix 851
WTS W2K
 

JEMILLER

VIP Member
Tim,

I have put this service pack on two SQL-based OneWorld installations with no ill effects. SP3 includes the hotfix 851 updates as well as some fixes for Data Transformation Services (DTS). This seems to be one of those rare Microsoft service packs that goes in clean.

Regards,


Justin Miller
justin.miller@teamspot.com

working with B7332 and XE on AS/400, NT, Solaris and AIX
 
I agree with the no ill effects. I needed the SP3 for SQL 7.0 to clear up
some SQL DTS (Data Transformation Services) issues, when using SQL DTS to
load the Siebel EIM (Enterprise Integration Mgt.) tables from JDE to import
data for the Siebel DB. Although the SP3 was not directly applied for JDE,
we did not experience any problems.

Best regards,

Eric E. Clark
Brandywine Computer Group, Inc.
Siebel Certified Professional
J.D. Edwards Certified Professional
Microsoft Certified Professional
eric_clark@brandywinecomputer.com
Phone: 513.607.8698
 

jgersic64

Active Member
Ditto here with the SQL7 service pack 3. We have been running SP3 for
months now without any problems or issues.

John

Xe, Sp14.2, NT/SP6a, SQL7/SP3, Metaframe 1.8
 

jwalker

Active Member
When I installed sp 3 for SQL 7 it went very smooth. The only problem I've
had so far is my maintenance plan isn't running correctly. I just recreated
it so we'll see what happens.

Xe sp13 - SQL 7 sp3 - NT 4 sp6a

Justin Walker
Systems Administrator
Colorado Christian University
303-963-3398
mailto:jwalker@ccu.edu
 
Top