Recently I needed to create an ODBC source that would allow an application to
read and write from a text file. An obvious question is: Why would I use ODBC
to read from and write to a text file? After all, ColdFusion supports this
easily using the tag. You'd be right if you were talking about a
purchased copy of ColdFusion. My requirements involved ColdFusion Express,
which doesn't support the tag.
Unfortunately, there's little, dare I say no, documentation on how to use
ODBC against text files. There was no information in the CF manuals, nothing
on Allaires Web site, and nothing in the ODBC documentation from Microsoft.
On the surface it seemed simple. But it wasn't. There were some surprises
along the way. Eventually the mystery was solved, and I was a... (more)