(Karen Gayda) Years ago when I was just breaking into the programming field I worked with Paradox databases. While Paradox pales in comparison to a database engine like SQL Server, it did have one interesting feature that has not yet been duplicated by Microsoft. When performing an insert into a tab
Other News
Connecting with Oracle: Finding and Setting a Configuration File Location
(Steve Callan) Last month’s “Connecting with Oracle” article dealt with properly configuring the tnsnames.ora file. Using a statistics-related analogy for a minute, you can have Type I and Type II errors with respect to your tnsnames.ora file. You can have a “good” tnsnames.ora file, but “reject” it
Migrating to .Net
(Godfrey Baker) Microsoft’s .Net initiative is widely regarded as the “next big thing” for distributed application development. The promise for Web development is clear: faster development, less custom coding, and increased stability. But what is required to migrate current applications to the new p
Getting Started with DB2 XML Extender for iSeries
(Marie Wilson and Sue Kelling) IBM’s eServer Business Solution Test (BST) team designs, implements, evaluates, and deploys customer-like scenarios. The team consists of iSeries developers in the Rochester laboratory who design scenarios that demonstrate how iSeries technology can be used to build e-
Insert on DB2 Linked Table Fails with Invalid Precision Error
When you are using the Host Integration Server 2000 ODBC Provider for DB2, if you try to use a linked DB2 table on an OS/390 Mainframe system from Microsoft Access, you may receive the following error: ODBC–insert on a linked table ‘MY_CODES’ failed [Microsoft][ODBC DB2 Driver] Invalid precisio
Take a Load Off: Archive Inactive Data
(Bryan F. Smith and Thomas A. Vogel) A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that’s rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed. With databases growing at an exponential rate,
Optimize Oracle Data Access
(Bob Beauchemin) You have two basic ways to improve data-access code performance in your database applications. The most straightforward way is to optimize the SQL statements that execute on the database server. A more subtle way, from a database client programming perspective, is to decrease the nu
Report on Oracle Text Index Sizes
(X. Jay Zhang) Oracle Text Index, formerly known as interMedia Index, is powerful for searching user specified text segments in a column or a document, and it is widely used in internet based applications like search engines or content management systems. An issue presented to a DBA, as usual, is to
Implementing Model View Controller (MVC) Design Pattern in .NET
(Nimesh Panchal)Design patterns are very useful to solve complex design problems if used properly. This article explains the basic concept of the Model View Controller (MVC) design pattern and also shows how closely .NET Framework can be used to implement the MVC design pattern with the one that ori
XML Q&A with Darshan Singh
In this article, a continuing series, managing editor Darshan Singh responds to questions asked by visitors. In this part: –Using WinInet to call a Web service –DOM and limiting the size of XML document –Binary data from Visual Basic 6.0 to ASP.NET Web service