[Openroad-users] Connecting to other Databases from OpenROAD

[Paul Andrews]

----- Original Message ----- 
From: "Robert Allely" <allelyr at poal.co.nz>
To: "International OpenROAD Users" <openroad-users at peerlessit.com>
Sent: Thursday, April 03, 2008 10:45 PM
Subject: [Openroad-users] Connecting to other Databases from OpenROAD


> Hullo there
>
> We would like to open a session on another database (SQL Server) from
> OpenROAD 4.1/0403
> Whats the best way of doing that? I assume a DBSessionObject Connect is
> required, but I have only done this with
> Ingres databases.

The official way to do this is via the ingres enterprise access product - 
http://www.ingres.com/products/enterprise-access.php - unfortunately at 
extra cost and a bit of hassle. the product acts as a gateway between 
non-ingres databases and the ingres infrastructure.

I know that in the past some people have used 3GL libraries to do their own 
DB access, but that's a lot of work.

It's probably going to be more hassle and cost than you think.

Paul (who did do an Oracle port some time back)

> Thanks
>
> Robert Allely
> Ports of Auckland NZ
>
> ***
> This e-mail is privileged and confidential.  If you are not the intended 
> recipient please delete the message and notify the sender at Ports of 
> Auckland Limited.
> ***
>