[U2] ODBC: database does exist
Hi all, I was trying to use VSG to connect the Unidata database. I was able to connect Unidata demo database, but once I change to our test database that I was not able to connect. I have change ud_database to point to our test database. The error message is database doesn't exist. Did I miss anything? Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] ODBC connections [ad]
Paul, Here is a document on how to configure Easysoft for UniVerse. In fact, It was first installed for UniVerse then UniData. Accessing ODBC Databases from IBM UniVerse/UniData http://www.easysoft.com/applications/ibm-universe-unidata/odbc.html You Can do a search on their website. Also, Here is a Success story on the U2UG website. See link and story below: Using the EasySoft ODBC-ODBC Bridge product, we are able to establish two-way connectivity between our Universe and Oracle databases. http://www.u2ug.org/index.php?module=pnForumfunc=viewtopictopic=127 Posted: 03.08.2004, 15:29 We have just successfully connected our Universe database with our Oracle database using Easysoft's ODBC-ODBC Bridge. To sum up what we have accomplished, so that we can add to your knowledge base: The requirement is to enable an ODBC connection between Universe and Oracle, both of which run on Unix. Either database must be able to initiate a transaction, i.e. Universe can connect to Oracle and Oracle can connect to Universe. We tried the Data Direct ODBC client for Unix to tie Universe to Oracle, but it served only the Universe BCI call to Oracle. It did not satisfy the need to connect to Universe from Oracle using Oracle's Heterogenous Gateway. Since Universe does not have an ODBC client that runs on Unix, we have to bounce the ODBC call from our Oracle database to an NT/2000 server in order to access the Universe ODBC client. EasySoft, in England, has a product they call an ODBC-ODBC Bridge. This is composed of an OOB server, which in our case runs on an NT/2000 box, and an OOB client, which can run from Windows, Unix or Linux. When an ODBC call is issued from the database, the OOB client on the local server calls the OOB server on the NT/2000 box, which then redirects the call to the ODBC client running on the NT/2000 server, which then proceeds to connect to the target database. Using the EasySoft ODBC-ODBC Bridge product, we are able to establish two-way connectivity between our Universe and Oracle databases. Licensing for the Easysoft ODBC-ODBC Bridge is based on the server. You can have as many clients as needed. They have a per server license plan, or you can get a site license if you need to have 4 or more servers on the same site. 8-) Hope this helps. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Janet Bond Sent: Tuesday, October 31, 2006 8:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] ODBC connections [ad] Hi Paul, If you would like to call me I can get you connected with one of the developers to discuss your options. Janet FusionWare Corporation Sales Operation Manager 1.800.266.2326 x1159 [ad] From: [EMAIL PROTECTED] on behalf of I-Rafferty, Paul Sent: Tue 10/31/2006 1:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] ODBC connections Thanks for the updates. Unfortunately Easysoft do not sell odbc drivers for Universe. We have decided to use one of the Oracle databases on Windows as a gateway to the Universe database. It seems to be the easiest way at this stage. Thanks again. Paul. -Original Message- From: Adrian Merrall [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 October 2006 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] ODBC connections Also on your Universe on HPUX via odbc you will need an HPUX driver either 32 or 64 bit. You can get this from http://www.easysoft.com http://www.easysoft.com/ I think from reading the OP Paul needs a Linux ODBC client that can speak to Universe on HPUX. If IBM only provide a windows based odbc client for Universe then he might have a problem here. A solution may be to use the JDBC driver provided by IBM as Janet suggested but use a odbc-jdbc bridge so the Oracle client can use ODBC. A quick google shows one from easysoft and one from Sun as part of the java stack. Plan B is to talk directly to the Universe jdbc driver of course but if you are going to be writing java code then consensus on the list is usually to use uniobjects directly. HTH Adrian --- 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/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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/
RE: [U2] ODBC: database does exist
Have you also set up the UCI.CONFIG file on the client end to match the new ud_databases reference? There is a UCI.CONFIG editor supplied with the latest ODBC installs which should allow you to amend as needed. Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: 01 Nov 2006 12:58 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC: database does exist Hi all, I was trying to use VSG to connect the Unidata database. I was able to connect Unidata demo database, but once I change to our test database that I was not able to connect. I have change ud_database to point to our test database. The error message is database doesn't exist. Did I miss anything? Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Do you run UV on Blades (IBM xSeries)?
If you run UV on Blades, please let me know (on or off line from U2UG). We need a reference. Thanks! Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC: database does exist
I think so because I am able to connect 'demo' database is on the same box with our test database. Do I have to define database in uci.config? leo DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = leo ACCOUNT = /datatel/live/collive Ud_database DATABASE=cconv UDTHOME=/usr/ud51 UDTACCT=/datatel/live/collive TRACE_LEVEL=3 Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Paterson Sent: Wednesday, November 01, 2006 9:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC: database does exist Have you also set up the UCI.CONFIG file on the client end to match the new ud_databases reference? There is a UCI.CONFIG editor supplied with the latest ODBC installs which should allow you to amend as needed. Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: 01 Nov 2006 12:58 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC: database does exist Hi all, I was trying to use VSG to connect the Unidata database. I was able to connect Unidata demo database, but once I change to our test database that I was not able to connect. I have change ud_database to point to our test database. The error message is database doesn't exist. Did I miss anything? Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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/
Re: [U2] [UV] ODBC connections
Hi Easysoft do an odbc gateway so your oracle app connects to the gateway, which in turn connects to the universe odbc. It does not have to know what the end point DB is. Rgds Symeon. On 31/10/06, I-Rafferty, Paul [EMAIL PROTECTED] wrote: Thanks for the updates. Unfortunately Easysoft do not sell odbc drivers for Universe. We have decided to use one of the Oracle databases on Windows as a gateway to the Universe database. It seems to be the easiest way at this stage. Thanks again. Paul. -Original Message- From: Adrian Merrall [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 October 2006 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] ODBC connections Also on your Universe on HPUX via odbc you will need an HPUX driver either 32 or 64 bit. You can get this from http://www.easysoft.com I think from reading the OP Paul needs a Linux ODBC client that can speak to Universe on HPUX. If IBM only provide a windows based odbc client for Universe then he might have a problem here. A solution may be to use the JDBC driver provided by IBM as Janet suggested but use a odbc-jdbc bridge so the Oracle client can use ODBC. A quick google shows one from easysoft and one from Sun as part of the java stack. Plan B is to talk directly to the Universe jdbc driver of course but if you are going to be writing java code then consensus on the list is usually to use uniobjects directly. HTH Adrian --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Ok - who knows InterCall?
Yes, yes, I know Why are we still using InterCall? - long story Question: Is there (and if so where) logging for Intercall transactions/calls to the host system? Thanks! PS - We didn't ever find out who/what deleted our line item file.. per your fabulous advice - it looks like it wasn't done in Universe... Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Ok - who knows InterCall?
intercall is a good interface .. we use it a lot. I don't remember ever seeing a loging function/setting available DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: [U2] Ok - who knows InterCall? From: Patricia Wilson [EMAIL PROTECTED] Date: Wed, November 01, 2006 12:02 pm To: u2-users@listserver.u2ug.org Yes, yes, I know Why are we still using InterCall? - long story Question: Is there (and if so where) logging for Intercall transactions/calls to the host system? Thanks! PS - We didn't ever find out who/what deleted our line item file.. per your fabulous advice - it looks like it wasn't done in Universe... Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- 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] Who uses Transaction Logging in Universe ???
I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Who uses Transaction Logging in Universe ???
It's working fine. Pretty robust, a lot of the things I thought I'd have to script/configure/modify work right outta the box. Biggest gotcha - if any of your item sizes are larger than 500K, you'll have to run with larger log files, increasing your exposure. If you're not using transaction commits, it doesn't guarantee data integrity. There's a performance penalty, exacerbated by poorly sized files. From: Patricia Wilson [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Who uses Transaction Logging in Universe ??? Date: Wed, 1 Nov 2006 16:35:06 -0500 I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Stay in touch with old friends and meet new ones with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/