(Jesse Smith) I’ve been working with Web services lately. After writing a bunch of code, I found a way to trick the .NET compiler into treating an XML stream as HTML. Doing so makes managing XML data a lot easier, as you can feed data returned from the web service right into your .Net script without
Author: SSWUG Research
You may receive an ‘OLE DB provider ‘‘ supplied inconsistent metadata for a column’ error message when you issue an SQL query statement against a DB2 table in Host Integration Server
In Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement: Server: Msg 7356,Level 16,State 1,Line 1 OLE DB provider ‘Provider Name’ supplied inconsistent metadata for a column. Metadata information was changed at
Standards-based Fusion
(Marta Bright) It wasn’t so long ago that the introduction of hot-pluggable hardware made it possible to add and remove devices from a running desktop computer—adjusting capabilities on the fly. Soon hot-pluggable server and network hardware brought power and flexibility to the enterprise, and datab
Information At Your Service
(Paul C. Zikopoulos) Data is the DNA of your business. It’s the stuff of which business projections are made, and it affects how decisions flow from those projections. It also informs the way the businesses measure their results. Although the Generally Accepted Accounting Principles don’t yet sugges
Maximize your development time with the CodeSmith code generation tool
(Tony Patton) Design patterns provide a standard approach to attacking common programming problems; however, developers often find themselves typing the same code over and over again. Code generation addresses this issue by providing the skeleton code necessary to get started. It can speed up develo
Enforcing Object Types in PHP: Using the Type Hinting Feature in PHP 5
(Alejandro Gervasio) Here we are again. Welcome to the last tutorial of the series “Enforcing object types in PHP.” As this article’s title suggests, this series introduces the basics of object type enforcement in PHP, covering some of the most common methods for checking types of objects in both PH
Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with Parameters
(Scott Mitchell) In Part 2 of this article series we looked at how to access relational database data using the AccessDataSource and SqlDataSource controls. However, in Part 2 we only looked at how to retrieve all of the records from a table, view, stored procedure, or ad-hoc SQL query. Often, we on
Oracle Challenges Google With New Enterprise Search Engine
(Charles Babcock) Oracle followed Google into the enterprise search arena, offering a search engine that it says can ferret out information buried in E-mail, corporate documents, and even mainframe applications.
Advanced Query Writing
(Andrew Oppel) SQL functions were introduced in Chapter 4. The topics that follow describe functions that were not covered in Chapter 4 but which you will find useful. In addition to character and mathematical functions, selected date and time functions are also included. Remember that all SQL
SQL Performance: Get The Right Index
(george.p.alexander) The power of getting the right index for your query is absolutely amazing. I was doing some checking on this test environment that was set up and had this Stored Procedure that takes around 4 minutes and 35 seconds. Our UAT guys wanted the thing to perform in a jiffy. Performanc