Brad,
 
The ODBCVIEW file is on the 3000 now, not in the archive on the client.  It's
now ODBCVIEW.PUB.SYS.
 
Log onto the user/acct which is logged as the DBA/Owner, start ISQL, and
execute the script...
 
:HELLO user.acct...
:ISQL
<header stuff>
> CONNECT TO 'dbename';
> START ODBCVIEW.PUB.SYS
 
<delay here with output - depending on the size of the DB>
 
>EXIT;
 
That's all there is to it.
 
Joe Geiser
 
----------
From:   Brad Straiton
Sent:   Thursday, August 01, 1996 8:07 AM
To:     Multiple recipients of list HP3000-L
Subject:        ODBC access to IMAGE-SQL
 
We get the following message when attempting to attach to the sample
MUSIC database that comes with IMAGE SQL
 
[Microsoft][ODBC DLL] Drivers SQLSetConnectOption failed[#0]
Driver not capable [#0] Invalid logon [#20003]
 
The HPMPEix logon information dialogue box ?looks? correct we
specified DBEnvironment MUSICDBE and a valid Userid & Account.
 
The PC side (HPPCAPI A.G1.05) appeared to install correctly.  The MUSIC
database has been set up as an SQL database data source via ODBC manager.
 
The only missing piece was ODBCVIEW which is referred to in the
documentation (dated (9/14/95) but was not in the zip file??
manager shows
 
Mike Moncrieff