We are using Open Ingres 2.0 on Open VMS, just recently we installed Ingres
NET, I was able to configure Ingres NET and retrive data on my Desktop, but
I simply can't figure out how to use the "-U" parameter. Due to security
concerns, I don't have the Password for our production account that owns the
database that I am attempting to connect to, in VMS I would simply issue
"isql dbname -Udba" and have full access. How do I get the same results
through my desktop, thanks.

Stephane,

It's the same process only now you'd do

isql vnode::dbname -udba

on your desktop. The important thing is that the user defined in the
vnode has security administrator privileges on the VMS machine. The one
you logged in as on VMS that allowed you to use -U must've had this
privilege.

By the way, having security administrator privilege is probably more
powerful than having the dba password - unless the dba is also the
ingres system administrator.

HTH
Paul

"Mason, Paul" <Paul.Mason (AT) ca (DOT) com> wrote

Thanks Paul, indeed that does work from the command prompt. I wasn't clear
in my request, I have no real need to use ISQL on my desktop, I simply find
it faster through a Telnet connection to our VMS box. What I am trying to
do is configure the ODBC driver to allow me to connect MS Access to my
Ingres Databases, I can get in as myself without a problem, but I can't
figure out how to get the DB_ADMIN access.