Dear Expert:
I am trying to setup ODBC to access Image Database, I follow the manual
(ALLBASE/SQL PC  API) did setup.
But when I use query tool (msquery) to access the DBE from PC to HP,
I always get "Logon error:27008".
 
I suspect I didn't seup ODBC.INI right, would you please point out how
to fix this?
 
Thanks in advance!
 
Here is the section in ODBC.INI I am using:
[sysa1]
Driver=C:\WINDOWS\SYSTEM\allbase.dll
Description=Partsdb (sysa1)
LastUser=#mpeix/sysa1:PartsDBE.MGR.YANG,ws#MGR.YANG/SESAME95
DefaultIsolation=
 
and Here is part of message I get
from DR.DeeBee Log File:
 
SQLAllocEnv
        0x00010000
        SQL_SUCCESS
SQLAllocConnect
        0x00010000
        0x00010000
        SQL_SUCCESS
SQLGetInfo
        0x00010000
        SQL_DRIVER_ODBC_VER
        [0]
        6
        1
        SQL_ERROR
SQLError
        NULL
        0x00010000
        NULL
        NULL
        NULL
        NULL
        0
        NULL
        SQL_SUCCESS_WITH_INFO
SQLDriverConnect
        0x00010000
        0x7001
        [9]DSN=sysa1
        SQL_NTS
        [4]_+
        256
        22729
        SQL_DRIVER_COMPLETE
        SQL_ERROR
SQLError
        NULL
        0x00010000
        NULL
        [5]S1000
        20312
        [19]Logon error: 27008.
        511
        19
        SQL_SUCCESS
 
P.S. Here is the list of my configuration
(1)
We are running HP3000, MPE Release 5, and use TCP/IP(ARPA) connection.
version of ALLBASE/SQL is A.F0.41
Version of HP ALLBASE PC API Library is A.F0.31
version of HP ALLBASE/SQL ODBC Driver is X.F0.14.a.
(2)
I created a test DBE (sqlsetup.sampledb.sys) and start the ODBCVIEW form  DBE.
(3)start the listner (anstart arpa debug), I am sure its running by look at
HPDANSLG.PUB.SYS
(3)
I am running TCP/IP, I have tried to sue the winsock.dll from WRQ Reflection
and Microsoft, I
got same message.
(4)On hp, my account is : mgr.yang, I only have account password which is
sesame95.
 
 
Thanks Again!