Can I Use InterMedia and VB to Index LONGs?

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 Received on Sat Jan 10 2004 - 00:38:07 CET