Spiggy Topes
01-09-2004, 03:38 PM
Hi all
I have an existing system written in Visual Basic 6.0 that uses ADO to
access an Oracle database - currently Oracle 8.1.7.4. I'm using the
Microsoft ODBC driver for Oracle, as we had all kinds of weird
problems with Oracles drivers. Microsoft's drivers don't support BLOB
and CLOB, so we're constrained to using LONGs.
I have functionality for storing external documents to the database
and for extracting and launching them. I'm using AppendChunk to put
the documents on the database, so there's no limitation on the types
of documents that can be stored. Typically, they'll be MS Office suite
stuff, most particularly MS Word.
The user would like me to add fuctionality that would allow him to
perform text searches on these stored documents. Everything seems to
point to InterMedia; but I'm having a hard time finding much useful
information on using it within a VB environment.
Has anyone done this? Will I need to make major changes to my code or
to existing database content in order to enable this? Anything else I
should be aware of before I commit to doing this?
Thanks
Robert Smith
I have an existing system written in Visual Basic 6.0 that uses ADO to
access an Oracle database - currently Oracle 8.1.7.4. I'm using the
Microsoft ODBC driver for Oracle, as we had all kinds of weird
problems with Oracles drivers. Microsoft's drivers don't support BLOB
and CLOB, so we're constrained to using LONGs.
I have functionality for storing external documents to the database
and for extracting and launching them. I'm using AppendChunk to put
the documents on the database, so there's no limitation on the types
of documents that can be stored. Typically, they'll be MS Office suite
stuff, most particularly MS Word.
The user would like me to add fuctionality that would allow him to
perform text searches on these stored documents. Everything seems to
point to InterMedia; but I'm having a hard time finding much useful
information on using it within a VB environment.
Has anyone done this? Will I need to make major changes to my code or
to existing database content in order to enable this? Anything else I
should be aware of before I commit to doing this?
Thanks
Robert Smith