Oracle Visual Basic Connectivity

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Anbazhagan

    Oracle Visual Basic Connectivity

    Hi,

    I'm using Oracle 9i with Spatial to store geographical data. It has
    only hundreds of features with very minimal veritices. I use OO4O
    (Oracle InProc) as component to access the oracle server from Visual
    Basic.

    It seems that it takes more time to retrieve the information stored.
    Some time back I, used same kind of data in Oracle 8 (without
    spatial). It worked fine with OLE DB provider.

    Since I need to access some of the VARRAY fields, I choose OO4O as
    middleware.

    How can I speed up the process (retrieving the information). Is
    there any other method to read the VARRAY fields in OLE DB (ADO).

    Thanks in advance.
Working...