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: [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
