ODBC driver for OpenInsight ? (OpenInsight Specific)
At 14 FEB 2002 12:07:15AM Peter Richards wrote:
Hi,
I realise OI has ODBC capabilities, but only from within an OI application. Is there an ODBC driver available (for the OI LH files), that I could use from other software (Delphi, VB), to access the LH files WITHOUT having to drop into the IO application ?
Thanks,
Peter
At 14 FEB 2002 05:17AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
No. Sorry. You can call REVCAPI from VB and get access to OE, thus being able to run R/Basic programs et al though.
World Leaders in all things RevSoft
At 14 FEB 2002 09:24AM Peter Richards wrote:
Hi,
] No. Sorry. You can call REVCAPI from VB and get access to OE, thus being able to run R/Basic programs et al though.
Is there any documentation about how to use REVCAPI.DLL ? I notice the properties on the file state "OpenEngine C language interface".
No doubt if VB can use it to access the OE, Delphi could do that also.
This method would still give me access to OI tables, right ? I guess this must be how OIPI works, it was written in VB originally I think.
Thanks,
Peter
At 14 FEB 2002 08:45PM Chris Callaghan wrote:
You can find the docs on RevCAPI here.
You'll also need to use VB4 16bit (or Delphi 1) unless you're keen on thunking - until OI32 that is
At 14 FEB 2002 09:04PM Chris Callaghan wrote:
Lets try that again properly
The RevCAPI docs can be found here.
But you'll need to use VB4 16bit or Delphi 1.0 unless you're keen on thunking - until OI32 that is
At 14 FEB 2002 11:19PM Peter Richards wrote:
Hi,
Thanks Chris, for the link and tips about thunking, I may need to do that, as I have Delphi 6. I think there will be adequate ODBC support in the borland.public.delphi.database.ado and borland.public.delphi.database.dbexpress newsgroups to do it (I hope).
Thanks also to the guys at Sprezzatura.
Regards,
Peter
At 15 FEB 2002 11:24PM Peter Richards wrote:
Hi Chris,
Do I _really_ have to go via the OpenEngine to access the LH files ? No doubt I do, if I use REVCAPI.
What about 'direct' access ? I see an interesting article on the Sprezzatura site (http://www.sprezzatura.com/revmedia/v3i1a1.htm) about the LH file structure.
From memory, there were 2 (DOS) programs , I think they were called LISTDICT and LISTVOL, they obviously accessed the REVMEDIA.* files firstly, and knew how to parse through the .LK and .OV files.
Assuming OI was not running (simple check on task list under Windows), and the purpose of the exercise was 'read-only', then if a person has a good understanding of the LH file structure, accessing the LH files 'directly' _should_ not be too hard ?
Regards,
Peter
At 16 FEB 2002 04:39AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
If you wanted to sequentially process ALL record in the file this would indeed be possible, or if to process some records you were prepared to process all, this would be possible!
World Leaders in all things RevSoft
At 18 FEB 2002 01:22AM Chris Callaghan wrote:
Understanding LH file structure is one thing, understanding how the records are hashed and their locations within a file is another…
With RevCAPI you can start a local OEngine. You can avoid the thunking step by grabbing a copy of OI32. If you're not a Works member then you should be able to download an evaluation copy.
Either way doesn't look pretty, but I think RevCAPI would still be the best way to do it.
At 28 FEB 2002 10:31PM Peter Richards wrote:
Hi,
I have been searching for either ODBC or JDBC drivers or other methods (REVCAPI) to access the LH files in OI.
Came across an open source project called "Maverick", see http://www.maverick-dbms.org/ or http://sourceforge.net/projects/maverick
It's written in Java, and could be adpated for OI LH files, as the basis is unidata, and is a 'pick style' open source DBMS.
Peter