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: [email protected] [mailto:[email protected]] On Behalf Of Chambers, Gary Sent: Tuesday, November 30, 2010 2:57 PM To: [email protected] 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 [email protected] [email protected] -- 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
