In a Crystal Enterprise (CE) environment with a SQL Server 7 APS database, when Service Pack 3 for SQL Server 7 is applied to the database, the password for username ‘sa’ can no longer be left blank. Therefore a password is entered. When an attempt is then made to restart the APS, it does not st
Author: SSWUG Research
DB2 Library Contents in Operations Navigator
(Kevin Vandever) Operations Navigator, or OpsNav, as it is affectionately known, has kicked up iSeries operation, administration, and application development several notches, yet many of you still use green-screen methods or other products that don’t compare with what OpsNav can do. One of those thi
Get Started with Oracle and PHP
(Sean Hull) Oracle is a powerful database for building web-based applications. PHP is famous for being quick and efficient; it can help you build fast applications that are not going to weigh down your database. Pair Oracle up with PHP, and you get a powerhouse combination. PHP (an acronym for P
Using XML Schemas and DTDs Together
(Greg Watson) This article focuses on how to validate an XML document against an XML Schema and a DTD at the same time. Additionally, the article focuses on how to transition from using DTDs exclusively to using both XML Schemas and DTDs. This type of transition is especially important for organizat
HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET
This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the ODBC managed provider.
DB2 UDB Scripting with Windows Scripting Host
(Chris Fierros) In this article we will cover in detail the more popular languages available for scripting on Windows, including Jscript and VBScript, that can be used to develop and deploy DB2 UDB scripts within the Windows Scripting Host (WSH) environment. Topics covered include: –Windows
Overview Of Oracle Enterprise Manager
Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle product
XML-Constraints with Scheme
(Erik Meißner) In complex authoring environments the usage of XML with its richer structure is a real advantage. But there is an almost infinite number of possiblities for our structure. If we add a DTD (like in SGML) to our XML-environment we can control the almost infinite number possibilities. Th
New CONNECT BY Features in Oracle Database 10g
(Jonathan Gennick) Recently I wrote about Oracle’s support for hierarchical queries in an OTN article titled Querying Hierarchies: Top-of-the-Line Support. While writing that article, I learned about some exciting, new features in Oracle Database 10g that strengthen Oracle’s already robust support f
The Long, Long Arm of SGML
(Kendall Grant Clark) Writing about XML invites a certain humanistic pretension, for several reasons. First, all this talk of universality and frictionless information exchange bears uncanny allusions, for those of us who inhabit certain parts of the ideological landscape, to what Christians used to