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

[Simon Lovell]

You'd need to either get a .dll file into the MainWin environment to 
access MySQL from UNIX, or if there is an ActiveX control which gives 
you what you need, you could find a way of installing that into the 
MainWin environment.  Of course, if you are going to a more Enterprise 
database, you can just use Enterprise Access.

Robert Allely wrote:

>>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.
>***
>
>________________________________________________________________
>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 
>  
>
>------------------------------------------------------------------------
>
>
>No virus found in this incoming message.
>Checked by AVG. 
>Version: 8.0.101 / Virus Database: 270.4.1/1519 - Release Date: 6/25/2008 4:13 PM
>  
>