[U2] UVODBC Connection Problem
The short story on this trouble is, as a test, I cannot get a connection between my PC and one of our uv servers nor can I get a successful test of a connection to a data source in the ODBC admin client. Details: After configuring UniVerseODBC version 4.0.2 build 7149 on a Windows XP SP3 machine I am not able to make a successful connection to files in a UniVerse account running in UniVerse 10.1.20 on HP/UX B.11.23. This work was done according to steps described IBM's January 2002 Version 10.0 ODBC Guide with some reference to Rocket's uvodbc-v10r3.pdf as well. I have configured uvodbc.config via UCI Editor as well as manually. My data source is listed in the Windows' ODBC Data Source Administrator under User DSN the same as the samples. In seeking some measure of confidence I did circle back and try to get one of the samples to work with no luck as well. Both samples as well as my source list as 'active' via HS.ADMIN: HS.SALES/u1/uv/HS.SALES YES HS.SERVICE /u1/uv/HS.SERVICE YES uvdbsizes /data/uvdbsizes YES 3 records listed. At present via the ODBC Data Source Administration when I invoke a Test Connection for any of the three data sources I get this result that I can't get beyond: [IBM][UVODBC][0301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect[]; State: IM976; universe code: 0; Msg: [IBM][SQL Client]UCI Connections to non UniVerse databases is not allowed. If nothing else, if anyone could point me to the Rocket manual or Brian Leach's write-up on this subject has helpfully suggested by Bill Brutzman that may be helpful. I found this information in a message dated Tue Oct 26 Subject: [U2] PC setup for to use ODBC. Thank you for reading and considering. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 gary.chamb...@omnicare.com ois-universesyst...@omnicare.com -- NOTICE -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material, the disclosure of which is governed by applicable law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and destroy the materials contained in this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVODBC Connection Problem
Gary: It looks like we are close to victory. The two keys are UCI and Win-ODBC. What data are we trying to connect to? Is it /data/uvdbisizes? I do not know if lower-case is allowed for an account. There is a scrub option in HSADMIN which I believe exposes and massages the MV data into a format that ODBC-SQL can handle. I would run the HSADMIN-Scrub option on the data file. Also, I have found that if the UV data file is too big, UV-ODBC gags. We copy some lighter weight data to another account for integration with FedEx and UPS. For trouble shooting, consider creating a small file with some example data and try to connect to it. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chambers, Gary Sent: Tuesday, November 30, 2010 2:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Connection Problem The short story on this trouble is, as a test, I cannot get a connection between my PC and one of our uv servers nor can I get a successful test of a connection to a data source in the ODBC admin client. Details: After configuring UniVerseODBC version 4.0.2 build 7149 on a Windows XP SP3 machine I am not able to make a successful connection to files in a UniVerse account running in UniVerse 10.1.20 on HP/UX B.11.23. This work was done according to steps described IBM's January 2002 Version 10.0 ODBC Guide with some reference to Rocket's uvodbc-v10r3.pdf as well. I have configured uvodbc.config via UCI Editor as well as manually. My data source is listed in the Windows' ODBC Data Source Administrator under User DSN the same as the samples. In seeking some measure of confidence I did circle back and try to get one of the samples to work with no luck as well. Both samples as well as my source list as 'active' via HS.ADMIN: HS.SALES/u1/uv/HS.SALES YES HS.SERVICE /u1/uv/HS.SERVICE YES uvdbsizes /data/uvdbsizes YES 3 records listed. At present via the ODBC Data Source Administration when I invoke a Test Connection for any of the three data sources I get this result that I can't get beyond: [IBM][UVODBC][0301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect[]; State: IM976; universe code: 0; Msg: [IBM][SQL Client]UCI Connections to non UniVerse databases is not allowed. If nothing else, if anyone could point me to the Rocket manual or Brian Leach's write-up on this subject has helpfully suggested by Bill Brutzman that may be helpful. I found this information in a message dated Tue Oct 26 Subject: [U2] PC setup for to use ODBC. Thank you for reading and considering. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 gary.chamb...@omnicare.com ois-universesyst...@omnicare.com -- NOTICE -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material, the disclosure of which is governed by applicable law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and destroy the materials contained in this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVODBC Connection Problem
Some key notes from a Gary Smith eMail from some time ago... UniVerse Server Administration 1. List activated accounts 2. Show UniVerse ODBC Config configuration for an account 3. Activate access to files in an account 4. Deactivate access to files in an account 5. Run HS.SCRUB on a File/Table 6. Update File Information Cache in an account Which would you like? ( 1 - 6 ) ? 1) ODBC needs the Dict Items in the @SELECT dictionary item a. Create @SELECT dictionary item to contain the fields you want to report on. i. ED DICT PRODUCT @SELECT I - to Insert Line 1 : PH Line 2 : BR.HITS MAX.DAYS BUYPKG COMM.CODE PRICE.LINE BUY.LINE Line 3 : Hit enter to exit add lines FI to save to file 2) Setup the file for ODBC access so that the system knows about the new file( or change has been made) a. LOGTO HS.ADMIN b. HS.ADMIN c. Enter 6 to update d. Enter ECLIPSE.ODBC when asked for account name e. When complete hit enter to return to the menu f.Hit enter to exit to the menu Even though HS.SCRUB is important the most important is to do #6 reset cache. Also you said no field name were showing in the @SELECT variable? You will need to add those manually to that @SELECT dictionary item. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chambers, Gary Sent: Tuesday, November 30, 2010 2:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Connection Problem The short story on this trouble is, as a test, I cannot get a connection between my PC and one of our uv servers nor can I get a successful test of a connection to a data source in the ODBC admin client. Details: After configuring UniVerseODBC version 4.0.2 build 7149 on a Windows XP SP3 machine I am not able to make a successful connection to files in a UniVerse account running in UniVerse 10.1.20 on HP/UX B.11.23. This work was done according to steps described IBM's January 2002 Version 10.0 ODBC Guide with some reference to Rocket's uvodbc-v10r3.pdf as well. I have configured uvodbc.config via UCI Editor as well as manually. My data source is listed in the Windows' ODBC Data Source Administrator under User DSN the same as the samples. In seeking some measure of confidence I did circle back and try to get one of the samples to work with no luck as well. Both samples as well as my source list as 'active' via HS.ADMIN: HS.SALES/u1/uv/HS.SALES YES HS.SERVICE /u1/uv/HS.SERVICE YES uvdbsizes /data/uvdbsizes YES 3 records listed. At present via the ODBC Data Source Administration when I invoke a Test Connection for any of the three data sources I get this result that I can't get beyond: [IBM][UVODBC][0301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect[]; State: IM976; universe code: 0; Msg: [IBM][SQL Client]UCI Connections to non UniVerse databases is not allowed. If nothing else, if anyone could point me to the Rocket manual or Brian Leach's write-up on this subject has helpfully suggested by Bill Brutzman that may be helpful. I found this information in a message dated Tue Oct 26 Subject: [U2] PC setup for to use ODBC. Thank you for reading and considering. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 gary.chamb...@omnicare.com ois-universesyst...@omnicare.com -- NOTICE -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material, the disclosure of which is governed by applicable law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and destroy the materials contained in this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Mac Connection to UniVerse
Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mac Connection to UniVerse
Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://www.macwise.com/ Regards, http://superuser.com/questions/105009/most-efficient-terminal-emulator-for-unidata-universe-or-other-mv-based-systemsRob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mac Connection to UniVerse
Actually I've never used a Mac so the built in terminal is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://www.macwise.com/ Regards, http://superuser.com/questions/105009/most-efficient-terminal-emulator-for- unidata-universe-or-other-mv-based-systemsRob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mac Connection to UniVerse
We quite successfully use Apple's free, built in Terminal to access UniVerse and SB+ Current Snow Leopard (10.6) version of OSX is best, as it's far easier to program the function keys to suit. Cameron -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Wednesday, 1 December 2010 16:48 To: 'U2 Users List' Subject: Re: [U2] Mac Connection to UniVerse Actually I've never used a Mac so the built in terminal is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://www.macwise.com/ Regards, http://superuser.com/questions/105009/most-efficient-terminal-emulator- for- unidata-universe-or-other-mv-based-systemsRob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ** This email and any attachments may be confidential and legally privileged. Please notify the sender immediately if you received this message in error. Please do not delete or alter this notice. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
