(Muthusamy Anantha Kumar) This article examines how to upload multiple files to a SQL Server table. There are many ways to do this. The method I would like to introduce takes advantage of the OSQL.exe utility and the TEXTCOPY.exe utility.
Other News
Create ASP.NET pages from XML data
(Leonardo Esposito) A lot of ASP applications produce their output based on the contents of one or more XML files. XSLT documents transform the browser-neutral contents of those XML files into browser-specific HTML. The transformation is always accomplished through VBScript or JScript code, and the
An introduction to coding SQL-DMO
(Rick Dobson) SQL Distributed Management Objects (SQL-DMO) is a set of COM objects that enables the programming of administrative tasks for Microsoft SQL Server. Because SQL-DMO is a collection of COM objects, you can program it by referencing its library and invoking its object’s properties and met
Migrating Your Access Database to Oracle
(Puneet Sangal) Migration to an Oracle database from an existing system can be daunting, especially when the existing database exhibits few or no similarities to the Oracle database structure. This Technical Note will compare and contrast two techniques for Microsoft Access-to-Oracle migration: the
Avoiding an Extreme Makeover
(Jonathan Boutelle and Rashmi Sinha) In the construction business, any remodeling job is a lot easier when the infrastructure has the right elements in place to support the desired changes—the wiring and plumbing meet current building codes and are situated in the proper location for a kitchen remod
Simplify Java Object Persistence with Hibernate
(Jeff Hanson) Storing and retrieving information for most applications usually involves some form of interaction with a relational database. This has presented a fundamental problem for developers for quite some time since the design of relational data and object-oriented instances share very differ
Tip: Use Universal Feed Parser to tame RSS
(Uche Ogbuji) RSS is supposed to be based on XML (or XML/RDF) standards. Unfortunately, the famous wild west community behind RSS has many renegade elements producing feeds that are not even well-formed XML. Mark Pilgrim’s excellent Universal Feed Parser is a great tool for parsing even ill-formed f
Using MySQL in a federated database environment
(Cindy Saracco) Learn how to configure DB2 II to read and write to tables and views managed by MySQL, an open source DBMS. Once you’ve done this, you’ll be able to join and union data in your MySQL database with other corporate data accessible to your DB2 II federated database. The DB2 II family
On Folly
(Edd Dumbill) In this week’s column, I’d like to indulge in some gentle fun at the expense of pundits and pronouncers. While XML is as rich a field as any for crackpots and timewasters, we must be careful not to pour cold water on experimentation and innovation. The topics of XML-oriented programmin
LISP is better than XML, but worse is better
(Rick Jelliffe) At the dawn of XML, some LISP fans would say that XML was just a crappy LISP. (The clueier LISP fans would use “s-expr” or SEXPR or S-expressions, as the Lots of Irritating Silly Parentheses syntax is known.) But Java plus XML plus the Beanshell interpreter is a pretty nice crappy LI