I am faced with a technical question that seems to have no clear cut answer. I have a lot of old poorly written code around an Interbase 5.0 database. I have ported my data to SQL 2000, but I am being told that I should also convert the data access within the old code from BDE to ADO due to limitations with Stored Procs. Now, I understand I will gain a lot from rewriting the data access, like instituting a standard data module and documenting some of the spaghetti. However, I think I might want to wait on the data access conversion and just try to use the BDE TTable components and connection ratehr than changing everything to ADO right now. Some of my programmers say I should convert it to ADO and some do not. It will cost more money and time to do the ADO conversion.
Is there a definitive right answer to the question: Must I convert data access to ADO when going form an Interbase backend to a SQL 2000 backend?