[Openroad-users] OpenROAD and Oracle

[Neil.Warnock at luminary.co.uk]

Hi Stephen, 

We've queried tables in SQL Server, LDAP and even Access (sorry!)
without Enterprise Access, so I imagine it will work for Oracle too. I
wouldn't recommend this for more than the odd query. EA provides a host
of good stuff that this clunky ADO workaround can't offer.

The trick is to have OpenROAD running on windows (AppServer on a windows
server is ideal) and use ADO/ODBC to access the database.  Here is a
presentation with some code fragments showing how to do it. 

http://www.iua.org.uk/conference/Autumn2005/NeilWarnock_1005.pdf Slide 8


As I said, it's clunky and a bit of a workaround, definitely not a
strategic development architecture. 

Just saw your followup email. You could build a generic inter-DB event
hub in OpenROAD that has DBMS-specific adaptors written in either Java
or a .NET CLR language (pref C#)

Hope this helps.
Rgds, 
 

Neil Warnock
Luminary Solutions
Tel: +44 (0)870 757 40 90  
Mob: +44 (0)771 265 0291  
Email: Neil.Warnock at luminary.co.uk

For more information on Luminary go to http://www.luminary.co.uk
 

-----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