OO4O (Oracle Objects for OLE) to ADO 
Author Message
 OO4O (Oracle Objects for OLE) to ADO

I need to "port" over an Oracle Application to MSSQL Server 2000.
Currently, the Application uses Oracle Objects and not ADO.
I would like to know if there is an "easy" solution for me to make this
leap.
Changing the entire code in the application would take too much time that i
just dont have.
I figured that if i make a "translator" object which would sit between the
Application and the Database
converting all OO4O methiods and properties into ADO methods and properties
so the Database could be manipulated by the same code.
I am just looking for any kind of tips or ideas (input) as to the best way i
could do this.
Remember, time is key here and i dont have the time to make all sorts of
fancy changes, i need it quick and dirty...

Any help would be greatly appreciated, i know this is a more advanced topic
and i would appreciate the help.

Thanks

Vinny



Mon, 28 Jun 2004 05:03:41 GMT
 OO4O (Oracle Objects for OLE) to ADO

Well, good luck!

I guess that you are familiar with both oo4o and ADO.

The only thing you can do as i see it, is to clean up your client computer
from all traces of the oo4o, and then build a dll that exposes the same
interfaces as the oo4o, let the code inside work as a wrapper to ADO.

So if you have lack of time...  start changing the client code instead ...

=)

//felix


Quote:
> I need to "port" over an Oracle Application to MSSQL Server 2000.
> Currently, the Application uses Oracle Objects and not ADO.
> I would like to know if there is an "easy" solution for me to make this
> leap.
> Changing the entire code in the application would take too much time that
i
> just dont have.
> I figured that if i make a "translator" object which would sit between the
> Application and the Database
> converting all OO4O methiods and properties into ADO methods and
properties
> so the Database could be manipulated by the same code.
> I am just looking for any kind of tips or ideas (input) as to the best way
i
> could do this.
> Remember, time is key here and i dont have the time to make all sorts of
> fancy changes, i need it quick and dirty...

> Any help would be greatly appreciated, i know this is a more advanced
topic
> and i would appreciate the help.

> Thanks

> Vinny



Tue, 29 Jun 2004 00:49:56 GMT
 OO4O (Oracle Objects for OLE) to ADO
I have made 'proxy classes' that emulate oo4o with ADO.
I have implemented only what I need and it works (ODatabase, ODynaset,
OField,
OFieldCollection). I even got a step further and implemented client/server
classes with it's own buffering (in our application ADO connection is in
different proccess).

You must be aware that ADO is slower than oo4o !!!!
Also, some queries must be adoped for ADO (remove comments).

Good luck. It took me about 1 day to make all.


Quote:
> I need to "port" over an Oracle Application to MSSQL Server 2000.
> Currently, the Application uses Oracle Objects and not ADO.
> I would like to know if there is an "easy" solution for me to make this
> leap.
> Changing the entire code in the application would take too much time that
i
> just dont have.
> I figured that if i make a "translator" object which would sit between the
> Application and the Database
> converting all OO4O methiods and properties into ADO methods and
properties
> so the Database could be manipulated by the same code.
> I am just looking for any kind of tips or ideas (input) as to the best way
i
> could do this.
> Remember, time is key here and i dont have the time to make all sorts of
> fancy changes, i need it quick and dirty...

> Any help would be greatly appreciated, i know this is a more advanced
topic
> and i would appreciate the help.

> Thanks

> Vinny



Tue, 29 Jun 2004 18:11:02 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. OO4O (Oracle Objects for OLE) to ADO

2. OO4O (Oracle Objects for OLE) to ADO

3. Using Delphi with Oracle Oracle Objects for OLE (OO4O)

4. oo4o - Oracle Object For OLE, non-distributable ?

5. Did anyone purchase ORACLE Object for OLE (OO4O) NT Version

6. MTS component with OO4O(oracle object for ole) ?

7. Oracle Objects for OLE (OO4O)...Need Help!

8. Oracle Objects for OLE; OO4O

9. OO4O Objects For Ole and DBMS_OUTPUT

10. Using ADO with Oracle Object for OLE

11. Using ADO with Oracle Object for OLE

12. Oracle OO4O OLE creation problem


 
Powered by phpBB® Forum Software