By Carl Lim – The following were the steps we took to create a Linked Server from SQL Server 2000 to Oracle 8i.
Author: SSWUG Research
SQL Server Boss Gives a Sneak Peek
With Microsoft Corp. coming off a major security push and moving headlong into its next major SQL Server release, code-named Yukon, eWEEK Senior Writer Matt Hicks recently sat down with the company’s SQL Server Vice President Gordon Mangione at Microsoft’s Redmond, Wash., offices. Mangione offered b
Java Programming with Oracle JDBC
Learn how to leverage JDBC, a key Java technology used to access relational data from Java programs, in an Oracle environment. Author Donald Bales begins by teaching you the mysteries of establishing database connections, and how to issue SQL queries and get results back.
Portal Vision
By Philip J. Gill – In theory, corporate portals have always been a good idea. Consolidate all of the content and functionality that an employee needs to do his or her job effectively into a single online window, and worker productivity will go up, says conventional wisdom. But until recently, corpo
Users Cast Wary Eye at Web Services
By CAROL SLIWA – IT professionals on an exploratory mission at XML Web Services One conference expressed keen interest in testing out new technologies to address some of their most painful application integration headaches. But their interest was tempered by a variety of concerns, including i
Tip: Work with schemas and namespaces
By Brett McLaughlin – This tip explains how the XML Schema specification requires one XML Schema per namespace, and shows you how to include more than one schema for a document and how to reference one schema from another.
The new OLAP APIs
by George Spofford – Historically data mining and online analytic processing (OLAP) have been solely human activities. In other words, it is humans who specify analytic models, build them, and then consume the results. But with the emergence of the Web services computing model, which involves the cr
Security Overhaul to Postpone SQL Server
By Matt Hicks – Built-in security development is at the heart of a delay of a major Microsoft Corp. database upgrade.An upgrade to SQL Server, code-named Yukon, will be delayed from late this year to early next year, said company officials here last week, to build more security features into
Installing Oracle8i on Red Hat Linux 7.1 / 7.2
by Jeff Hunter – The following article is a summary of the steps required to successfully install the Oracle 8i (8.1.7) database on Redhat Linux 7.1 and 7.2.
XML, Part 3: XSLT Stylesheets
By Heath Stewart – This tutorial will cover basic transformations using XSLT to produce HTML. XSLT can do way too much, however, to cover everything in this tutorial.