Hi Bill You don't need CONNECT privileges to use BCI, unless you are making a BCI connection back into UniVerse. The BCI demo program supplied with UniVerse does that, which is why it asks for the privileges. If you are accessing e.g. SQL Server, it's down to the role of the user you specify in the connection.
If you do need to connect back into UniVerse, the SQL catalog is normally owned by either root or uvsql, depending on who you nominated when UniVerse was first installed. Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 09 December 2009 11:59 PM To: U2 Users List Subject: Re: [U2] [UV] BCI Connectivity I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 "BASIC SQL Client Interface Guide" but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 >GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in >LOGTO UV >uv are unClear. Suggestions would be appreciated. --Bill _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/09/09 19:41:00 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
