dbTalk Databases Forums  

fastest access to oracle database

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss fastest access to oracle database in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
abdoul85
 
Posts: n/a

Default fastest access to oracle database - 11-09-2007 , 10:07 AM






hello,
I have to replace old and slow RDO in Visual Basic Application.
What is the fastest and most effective way to do this ?

Is oo4o a good suggestion ? Or maybe something different ?

what is the difference between OCI and oo4o ?

thanks a lot for any help
greetings


Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: fastest access to oracle database - 11-09-2007 , 01:50 PM






abdoul85 wrote:
Quote:
hello,
I have to replace old and slow RDO in Visual Basic Application.
What is the fastest and most effective way to do this ?

Is oo4o a good suggestion ? Or maybe something different ?

what is the difference between OCI and oo4o ?

thanks a lot for any help
greetings
Did you mean ADO?

Look at Oracle's SOA Suite.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #3  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: fastest access to oracle database - 11-11-2007 , 09:49 AM



On Fri, 09 Nov 2007 08:07:11 -0800, abdoul85 <abdoul85 (AT) gmail (DOT) com>
wrote:

Quote:
hello,
I have to replace old and slow RDO in Visual Basic Application.
What is the fastest and most effective way to do this ?

Is oo4o a good suggestion ? Or maybe something different ?

what is the difference between OCI and oo4o ?

thanks a lot for any help
greetings
OCI = Oracle Call Interface. It is the lowest level API written in C
to get access to an Oracle database.
It probably can be called from VB, but it is completely different from
RDO.
OO4O (Oracle Objects for OLE) is more less akin to RDO, however newer
interfaces are OleDB and ODP .NET. Tutorials for all of those
interfaces are on http://otn.oracle.com, hit Tutorials on the OTN home
page.

--

Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #4  
Old   
abdoul85
 
Posts: n/a

Default Re: fastest access to oracle database - 11-19-2007 , 09:47 AM



Is there any sense to write in OCI ? It seems to be difficult :]
have You any experience about that ?
I think that using oo4o will be better solution than writing my own
dll in OCI using cpp and the using it in my VB application


Reply With Quote
  #5  
Old   
DA Morgan
 
Posts: n/a

Default Re: fastest access to oracle database - 11-19-2007 , 10:38 AM



abdoul85 wrote:
Quote:
Is there any sense to write in OCI ? It seems to be difficult :]
have You any experience about that ?
I think that using oo4o will be better solution than writing my own
dll in OCI using cpp and the using it in my VB application
One writes C or C++ because they need to. What compelling need is
there for doing something outside of the environment supported by
JDeveloper?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.