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

[Robert Allely]

>From Unix? I mean with openROAD running on unix using mainwin .

Robert 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Colin Hay
Sent: Thursday, 26 June 2008 12:04 p.m.
To: International OpenROAD Users
Subject: Re: [Openroad-users] FW: Connecting to other Databases from
OpenROAD


I have OpenROAD talking to MySQL if that's any use  


Colin Hay
Database Administrator
Fintechnix
Level 3,
55 Clarence Street,
Sydney

colin.hay at fintechnix.com
Phone: +61 2 8234 8276


 

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

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

________________________________________________________________
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 email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Specialist providers of back and front office systems for the financial
services industry.
Featuring:  Fintechnix(r)
Disclaimer: 
Notice: This message contains privileged and confidential information
intended only for the use of the addressee named above. If you are not
the intended recipient of this message you are hereby notified that you
must not disseminate, copy or take any action in reliance on it.
Any views expressed in this message are those of the individual
sender,except where the sender specifically states them to be the views
of Fintechnix Pty Ltd.

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