[Openroad-users] FW: Connecting to other Databases from OpenROAD

[Robert Allely]

 I guess its unlikely- but is there a chance that there is a suitable
external typelib in the unix openroad that can
allow this to work on unix?  I am using 4.1/0403 OR.

It has some Microsoft ActiveX libraries available -eg Microsoft ActiveX
Plugin-
  but not the same as I am using on windows platform OpenROAD.
(Microsoft ActiveX Data Objects 2.8 Library)

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Paul White
Sent: Thursday, 10 April 2008 12:50 p.m.
To: International OpenROAD Users
Subject: Re: [Openroad-users] Connecting to other Databases from
OpenROAD

Hi Robert,

There was an example posted to the list last month.  Start here.

http://www.peerlessit.com/pipermail/openroad-users/2008-March/001121.htm
l

Paul

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Robert
Allely
Sent: Thursday, 10 April 2008 10:45 AM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Connecting to other Databases from
OpenROAD

Hi Jonathan 

Disregard my previous email, I now have the OpenROAD class browser
looking at an external class - do you have an example of the method to
open a sqlserver Database and run a select loop into an OpenROAD array?

Thanks
Robert 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Jonathan
Barton
Sent: Friday, 4 April 2008 7:31 p.m.
To: International OpenROAD Users
Subject: Re: [Openroad-users] Connecting to other Databases from
OpenROAD

Hi Robert

When you say Session - what kind of work do you want to do? 
Do you want to run everyrthing in your app against sql server or just
the odd query?

If it is just the odd query we have created an external object and used
ADO (Microsoft ActiveX Data Objects 2.8 Library).

Regards.

Jonathan

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Robert
Allely
Sent: 03 April 2008 22:45
To: International OpenROAD Users
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.

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

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

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

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


This incoming email to UWE has been independently scanned for viruses by
McAfee anti-virus software and none were detected


This email was independently scanned for viruses by McAfee anti-virus
software and none were found

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

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

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
***
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.
***

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

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

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

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

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

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe 
***
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.
***