When I started programming about 15 years ago, the conventional wisdom was to use middleware that would let you connect to different databases without changing your code - ODBC comes to mind. Nowadays, ADO seems to be the answer. However, is the conventional wisdom still the way to go?
My application is currently scheduled to work with MS Access type MDB files and MS SQL Server. Therefore, I have been developing it using ADO; that means, in Delphi 2005, using the dbGo components. I am wondering if there is a better solution out there? I am thinking that I might like to move to Oracle or SQL Anywhere, or any other DBMS that might be in use. Is ADO my best solution? I don't mind minor mods to the source code but I really don't want completely separate applications. I know this might be a religious question...I am not trying to bring on a war, just wondering what you out there think on the subject. Thanks for playing... jamie
