RE: [U2] connection within UniVerse and Oracle
We came up with a novel solution to pass data back and forth between UV (10.1.8 on HP-UX) and Oracle (10.1.0.3 on IA HP-UX). We wrote a GCI wrapper for the Oracle OCI client that allowed us to call a set of stored procedures we wrote on Oracle from Databasic. This allows us to connect, enqueue, dequeue and commit using Oracle Advanced Queues. They work very well. We never really had much luck with ODBC on Unix for UV. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 28 February 2006 04:21 To: u2-users@listserver.u2ug.org Subject: [U2] connection within UniVerse and Oracle I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. Regards Frederick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] connection within UniVerse and Oracle
I think i would only use vb.net IF there was something specific that the uv odbc connection does not provide. I have found that for most applications the ODBC connection is not too slow and for most MV guys it is much easier and faster to learn the vb.net. And the price is right .. Tuesday, February 28, 2006, 5:52:52 PM, you wrote: MR Depending on what you are trying to do, ODBC (slow and awkward IMO) or a MR VB/VB.Net program that can easily access both databases would be a MR very easy MR way to go about it. You would need uniobjects or Redback to connect to MR Universe. MR Again, depending on your goals, there are some tools out there like the MR stuff from ON Corp. MR HTH MR Mike R. MR -Original Message- MR From: [EMAIL PROTECTED] MR [mailto:[EMAIL PROTECTED] On Behalf Of MR [EMAIL PROTECTED] MR Sent: Monday, February 27, 2006 11:21 PM MR To: u2-users@listserver.u2ug.org MR Subject: [U2] connection within UniVerse and Oracle MR I am trying to establish a connection between UniVerse 10.1 ( aix unix ) MR and Oracle (Window 2003), has anyone done this before? I was told to MR either use socket connection or ODBC. It seems that it is not that easy to MR use socket connection talking to Oracle, so I am thinking of using ODBC? MR Any ideas. Thanks. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Jazz isn't dead, it just smells funny - Frank Zappa --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection within UniVerse and Oracle
On 2/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. BCI is supposed to work for this, but it really depends on the precise combination of operating system and ODBC data source. We were never able to talk to Sybase from UniData running on HP-UX, but hopefully you'll have better luck. If there is a driver and driver manager available for your combination, then you should be in business. -- Wendy ... who hopes we put the list config back the way it was... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection within UniVerse and Oracle
We use OpenLink ODBC drivers to get Universe 10.1.14 to talk to MS SQL Server 2000 We use the standard Basic SQL Client Interfaces and have no problems Initial setup is a bit a of pig though Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak Sent: 28 February 2006 14:40 To: u2-users@listserver.u2ug.org Subject: Re: [U2] connection within UniVerse and Oracle On 2/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. BCI is supposed to work for this, but it really depends on the precise combination of operating system and ODBC data source. We were never able to talk to Sybase from UniData running on HP-UX, but hopefully you'll have better luck. If there is a driver and driver manager available for your combination, then you should be in business. -- Wendy ... who hopes we put the list config back the way it was... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection within UniVerse and Oracle
Depending on what you are trying to do, ODBC (slow and awkward IMO) or a VB/VB.Net program that can easily access both databases would be a very easy way to go about it. You would need uniobjects or Redback to connect to Universe. Again, depending on your goals, there are some tools out there like the stuff from ON Corp. HTH Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 27, 2006 11:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] connection within UniVerse and Oracle I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. Regards Frederick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] connection within UniVerse and Oracle
I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. Regards Frederick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/