Many software applications benefit from storing their data in database management systems. In this book excerpt, the author show you how to connect to a SQL Server using ADO.
Author: SSWUG Research
Oracle’s Groupware Challenge
By Lori MacVittie – In early July, Oracle purchased Steltor, a small and relatively unknown groupware developer. Just a week later Oracle announced its intention to offer the suite as its own entry into the low-growth groupware arena.IBM’s Lotus unit and Microsoft have owned the groupware sp
Help: ADO Truncates milliseconds from SQL Server Datetime columns
When I query a SQL Server Database using ADO 2.6 – the data from Datetime columns comes back WITHOUT Milliseconds.
How to Interact with SQL Server’s Data and Procedure Cache
by Randy Dyess – As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool t
Microsoft’s JDBC Driver for SQL Server Stacks Up Against Competition
Microsoft recently released its SQL Server 2000 Driver for JDBC. Dr. Heinz Kabutz demonstrates how he put this Type 4 driver to the test against some other JDBC drivers currently available, including the JDBC-ODBC Bridge. He also explains why as a Java developer he’s so pleased to finally see this M
The XMLPULL API
by Elliotte Rusty Harold – Most XML APIs are either event-based like SAX and XNI or tree-based APIs like DOM, JDOM, and dom4j. Most programmers find tree-based APIs to be easier to use, but they are less efficient, especially when it comes to memory usage. A typical in-memory tree is several times l
Data Types Undefined in XML Schema?
The XML Schema Working Group was tasked with adding the two most important pieces to the XML puzzle: Schema Definitions and a Data Type Libary. Criticism rises now as more and more people work with the resulting specifications, including XML Schema part 2: Datatypes.
Xerces C++ 2.0.0 released
Version 2.0.0 of the popular XML parser Xerces C++ has been released.
XHTML 2.0: The Latest Trick
by Kendall Grant Clark – If the Semantic Web means anything, it means changing the Web’s infrastructure just enough so that inter-machine exchanges become as ubiquitous, cheap, and easy as inter-human exchanges already are. One vital goal, however, is to make inter-machine exchanges possible without
Tip: Make choices at runtime with XSLT parameters
By Nicholas Chase – Extensible Stylesheet Langauage Transformations provide the ability to perform sophisticated manipulation of data as it is transformed from one form to another. You can increase their capabilites even further through the use of parameters that can be specified at runtime. This ti