Migrating from IBX to ADO

Hello all.
I've been using IBX to connect my application to an Interbase Database but
now I must use an Oracle Database and possibly SQL Server. So I'm thinking
in changing to ADO components so I can access any kind of Database. I would
like to know what is the "painless" way to do this. I'm using DataSets in
IBX but in ADO they seem to work a little diferent (no property for the
insertsql, deletesql, etc?).
If anyone could give me some guidelines for this kind of miggration I would
apreciate it.

Thanks in advance
Best Regards

Goncalo Martins


.

Relevant Pages

  • Re: ADO in threads
    ... with the db but I know for sure that the ADO components (ADOCommand, ... continuously trying to access the database. ... maybe the bug is in SQL server 2005. ... the MDAC component checker. ...
    (borland.public.delphi.database.ado)
  • A TField Descendant that emulates Boolean for IBX?
    ... emulate a Boolean field for IBX (or IBO, I know FIBPlus has something built ... by using CHARfields in the database. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: FIBPlus und Dlls
    ... Bei Nutzung von IBX und Dlls muss ja bekanntlich jede Dll ihre eigene ... ich habe unter IBX zwar für jede DLL eine Database genutzt, ... aber durch SetHandle(Handele der Database der EXE) geöffnet. ...
    (de.comp.lang.delphi.datenbanken)
  • Detecting connected users (and username) to a Database File
    ... I like to detect what number of users (and theirs usernames) that are ... connected to a database. ... I'm using Delphi 7 and IBX 7.08... ...
    (alt.comp.lang.borland-delphi)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)