I like standards. There are so many to choose from. In Delphi 2007, you can use either the BDE components or the dbExpress components or the ADO components (or the InterBase-specific components, but those only talk to InterBase databases).
I have a Progress (OpenEdge/whatever they're calling themselves today) database. It supplies an ODBC driver. Oh, look. There's no ODBC in the list above. Fortunately, the BDE also accesses ODBC databases as if they're BDE databases. Unfortunately, the BDE hasn't been maintained for about eight years, so the access violations I get when I try to access the OpenEdge database through ODBC through the BDE will never, even be fixed. Fortunately, Windows XP (at least) has an ADO driver for accessing ODBC data sources. Unfortunately, when I access the OpenEdge database through ODBC through ADO, Delphi can't see the indices on the tables, which are slightly important. Unfortunately, dbExpress can't natively talk to ODBC data sources. Fortunately, there's an open source dbExpress driver to do that. Unfortunately, when loaded, it claims it doesn't support dbExpress 2.5, which I suppose is what Delphi 2007 has. Fortunately for me, it;s the end of the day and I can go home. Unfortunately, I have to come back to work tomorrow and find a way to make this work. I hate more or less everyone; it's too much work to be more discriminating. -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- You have the cutest little suppurating sores! Has anyone ever told you that? -- Glory (Buffy the Vampire Slayer, "Family") ---- --- --
