August, 2008 Update.
I added in SqlServerCE support (version 3.1 for desktop).
Now there is SqlServer, Access, Excel, Text and SqlServerCE.
SqlServerCE was a little tricky at first, but I got it running.
This is an early preview, and I don’t have alot of comments or explanation yet.
Download the code HERE (Right Click / Save As works best)
One of my first real jobs my company had to support multiple RDBMS (Relational Database Management Systems).
Sql Server 6.5, 7.0, Sybase, and Access/Jet (Although I don’t consider Access/Jet a real RDBMS).
Oh, the countless number of "IF gDataBaseType="Access" then" statements. YUCK!
I had been advising people to use the Factory Pattern for multiple RDBMS support, but finally decided to author a demo.
You’ll need Sql Server 2000,2005 or 2008. You don’t have to have those, but it helps.
Most important instruction. Read the README.txt file before unzipping.
Again, read the README.txt file BEFORE unzipping.
I’ll followup with this at some point, but wanted to get the sneak preview out the door.