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
