[Openroad-users] OpenROAD and Oracle

[Pete Rabjohns]

Yes,

But not without using one of the following technologies:-

1. A 3GL Library which access Oracle via OCI etc. Requires Oracle client
on the machine.

2. An ActiveX control which accesses the Oracle DB (written in VB, C++
etc (VB Is the easiest I think).

3. A very crude spawning of SQLPLUS to output the results of the query
(or to run a query) into a text file and then read it back in OpenROAD.
(Requires the Oracle client on the machine). Not elegant, but probably
quickest to implement.

4. Embed an IE active x control and use the Oracle HTTP Server to run a
query for you. I've never tried this approach myself, but in theory it
would work.

5. Embed the Oracle query into a remote Web Service, and call it using
the MSSOAP active x control...

There are probably a few other ways, but the best approach really
depends on what you are trying to achieve, and how familiar you are with
the other technlogies.

If you need quick and dirty then option 3 is good, whereas if you want
an more generic and elegant approach, then I would go for Option 2, this
allows you to use an ADO type approach with different ActiveX objects
for managing Connections etc. 

I tried using the ADO objects directly in OR4.1 before, but as some of
the method names are OR reserved words it complained. Also if you want
to go down the ActiveX road, you really need to be on the latest version
of OR4.1 (SP3).

You can try accessing the ADO objects directly in OR4.1 - the bugs
present when I tried it may have been fixed by now.

Regards,

Pete




-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
stephen.mcculloch at falkirk.gov.uk
Sent: 21 December 2006 13:43
To: OpenROAD Users
Subject: [Openroad-users] OpenROAD and Oracle

Hi all

Is it possible to query an Oracle table from within OpenROAD 
without using Enterprise Access for Oracle?

Thanks

Stephen

Stephen B McCulloch
Software Developer
----------------------------
Corporate & Commercial Services
ICT Infrastructure (Software Development)
Falkirk Council,
Municipal Buildings,
West Bridge Street,
Falkirk, FK1 5RS
Scotland, UK
------------------------------------------
Telephone : (01324) 501523
Fax          : (01324) 501516
E-mail      : stephen.mcculloch at falkirk.gov.uk


************************************************************************
**
The information contained in this e-mail is confidential and is intended
only for the named recipient(s). If you are not the intended recipient,
you must not copy, distribute or take any action or reliance on it. If
you have received this e-mail in error, please notify the sender. Any
unauthorised disclosure of the information contained in this e-mail is
strictly prohibited.

The views and opinions expressed in this e-mail are the senders own and
do not necessarily represent the views and opinions of Falkirk Council.
************************************************************************
**

_______________________________________________
Openroad-users mailing list  Openroad-users at peerlessit.com

To unsubscribe please click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe please click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe