Hi
I currently have an app written using the Mydac components, and am now considering extending it to other database servers. The main one of interest is Oracle, so ODAC is in the picture. Is it as simple as it appears in that I just need to replace the MyDAC components with the corresponding ODAC ones? I haven't used any platform specific SQL (purposely). The only real crunch is that the app is designed as a standalone, with no install. It's currently in BDS2006 on a Win32 platform, so I presume I'd also need to chnage to .NET to stay with the 'no install' app.
Does anyone have any experience in this, or any advice they can give on 'gotchya's'?
TIA
Steve
MyDAC app porting to ODAC
If you want the application to work with Oracle and MySQL servers simultaneously, you should better create different data module(s) for each server.
Otherwise, you can replace MyDAC classes with ODAC ones by a simple text editor like Notepad (your form should be saved as a text). Probably your application will become uncompilable because of some different methods and properties in ODAC and in MyDAC. There should not be any problems ajusting the application to be compilable.
Otherwise, you can replace MyDAC classes with ODAC ones by a simple text editor like Notepad (your form should be saved as a text). Probably your application will become uncompilable because of some different methods and properties in ODAC and in MyDAC. There should not be any problems ajusting the application to be compilable.