e3000 Folks;
MY customer is testing a product called 'Quality Manager'
from Ascential which is an Informix product.
I have set up the ODBCSE listener and installed the ODBC 32 bit driver
from HP ODBCSE. I have tested this with Microsoft Access and Excel and
all works correctly.
I've turned logging on the ODBC driver on ie; (odbclink.log) and
I examine the ODBCLOG.ODBCSE.SYS file on the e3000 to see whats happening.
When I run the PC product 'Quality Manager', I am able to connect via ODBC
and am presented with a list of TABLES. I select one of the TABLES to get
a list of FIELDS and I get an error. The error is as follows;
SQLExecDirect(-1) hdbc=0 hstmt=1 SELECT COUNT(*) FROM CDPNOTES
SQLError(0) hdbc=0 hstmt=1 pfNativeErr=-
1,szErrorMsg=[ODBCLINK Host] [Allbase]Table/View [log in to unmask] not found. (DBERR 2206)
Do I need to issue the ATTACH command in the following way;
ATTACH WITH OWNER = MGR@777 instead of the default CUSLIB?
(I'm thinking the SELECT clause without the OWNER part might work?)
Will this enable the ODBC statement
SELECT COUNT(*) FROM CDPNOTES
to function?
********************************************************************************************
Here is what IMAGE/SQL says;
DATABASE.MSI:IMAGESQL
HP36385B B.G2.15 IMAGE/SQL Utility WED, JUL 25, 2001, 9:07 AM
(C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993
>>SET TURBODB CUSLIB.DATABASE.MSI
>>SET SQLDBE CISDBE.DATABASE.MSI
>>DISPLAY OPTIONS
Current base : CUSLIB.DATABASE.MSI
Current SQLDBE : CISDBE.DATABASE.MSI
Echo : ON
Command Logging : ON
Current Log File : ATCLOG.DATABASE.MSI
*** Database is attached.
>>DISPLAY USERS
ATTACHED BASES : CUSLIB.DATABASE.MSI
DBEnvironment : CISDBE.DATABASE.MSI
Owner Name : CUSLIB
USER LOGON DBOPEN MODE USER PASSWORD USER CLASS
---------- ----------- ------------- ----------
MGR.MSI 1 LOKKEDUP 1
>>
Here is some info from ISQL SYSTEM table;
SELECT * FROM SYSTEM.TABLE WHERE NAME LIKE 'CDPNOTES%';
--------------------+--------------------+--------------------+------+-----
NAME |OWNER |DBEFILESET |TYPE |RTYPE
--------------------+--------------------+--------------------+------+-----
CDPNOTES |CUSLIB |SYSTEM | 0|
CDPNOTES_V2 |CUSLIB |SYSTEM | 1|
CDPNOTES_V1 |CUSLIB |SYSTEM | 1|
---------------------------------------------------------------------------
Number of rows selected is 3
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
SELECT * FROM SYSTEM.GROUP ;
--------------------+--------------------+--------------------+-----------
USERID |GROUPID |OWNER |NMEMBERS
--------------------+--------------------+--------------------+-----------
CUSLIB_1 |CUSLIB_1 |MGR@MSI | 0
IWSLIB_2 |IWSLIB_2 |MGR@MSI | 0
LIBDB_2 |LIBDB_2 |MGR@MSI | 0
CUSLIB_2 |CUSLIB_2 |MGR@MSI | 0
LIBDB_0 |LIBDB_0 |MGR@MSI | 0
LIBDB_64 |LIBDB_64 |MGR@MSI | 0
CUSLIB_0 |CUSLIB_0 |MGR@MSI | 0
CUSLIB_64 |CUSLIB_64 |MGR@MSI | 0
IWSLIB_0 |IWSLIB_0 |MGR@MSI | 0
IWSLIB_64 |IWSLIB_64 |MGR@MSI | 0
---------------------------------------------------------------------------
Number of rows selected is 10
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
SELECT * FROM SYSTEM.TABAUTH WHERE NAME='CDPNOTES';
--------------------+--------------------+--------------------+-----------+
USERID |NAME |OWNER |NCOL |
--------------------+--------------------+--------------------+-----------+
CUSLIB_64 |CDPNOTES |CUSLIB | 0|
CUSLIB_2 |CDPNOTES |CUSLIB | 0|
CUSLIB_1 |CDPNOTES |CUSLIB | 0|
---------------------------------------------------------------------------
Number of rows selected is 3
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
Thanks
*
Joseph Whitlock
The Boeing Company
P.O. Box 3707
Mail Code 6C-LU
Seattle, WA. 98124
Phone: 425-234-1478
Email: [log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|