OI & ODBC (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 10 NOV 1998 05:38:37PM Warren wrote:

OpenInsight Specific

Which way is it with OI & ODBC?

ODBC allows OI to retrieve and update other DB's (e.g. MS Access)

or

ODBC allows other DB platforms (e.g. MS Visual FoxPro) to retrieve and update LH files.

Or some combination of the above (retrieve from LH files only).

Thanks

At 10 NOV 1998 06:05PM Dave Pociu wrote:

With OI you can access LH tables and Lotus Notes.

With OI + ODBC drivers you can access outside databases ( Access, MS SQL, Oracle, etc.)

Other applications cannot access LH directly ( there is no ODBC driver for LH tables). There has however been an OCX control written that will allow you to call OI subroutines from any other application that can use OCX controls. Through that you can access LH data.

Hope this clarifies things

Dave

At 10 NOV 1998 07:53PM Warren wrote:

What are the basic mechanics of accessing a foreign table using ODBC? Is it similar to using a 'bond' in ARev?

Thanks again.

At 11 NOV 1998 05:37AM [email protected],[url=http://www.sprezzatura.com]Sprezzatura Ltd[/url] wrote:

Warren,

We covered some of the basics of ODBC access via OI in the past issues of SENL. Check the dropdown below to get our website to find the issues.

[email protected]

Sprezzatura Ltd

World Leaders in all things RevSoft