Dear Expert:
We just upgrad image sql on a HP3k running MPE/iX 5.0. I am trying to
setup ODBC connection to IMAGESQL, I got error:
[39]PC Sockets error: 10054.(PCSockets !1).
From the debug message in HPDAARLG.PUB.SYS, It looks like I had a
valid connection, but I don't know why I got above error message.
I list my configurations and debug messages below, would you take a
moment to check it out and give me some directions?
Thanks in advance
Haixu
(1)Configuration:
(1.1)ODBC.ini setup is:
[sysz1]
Driver=C:\WINDOWS\SYSTEM\ALLBSE.DLL
Description=Partsdb (sysz1)
LastUser=#mpeix/sysz1:PartsDBE.PUB.YANG,ws#MGR.YANG/SESAME95
(1.2)winsock.dll I have tried to use both MS version and WRQ version, I got
same error message
(1.3)HP3K, MPE/iX 5.0 OS
(1.4)Current ALLBASE/SQL version installed: A.G0.26 /*output from SQLVER */
(1.5)ALLBASE.DLL: Version: A.G0.04 /* output of WHAT ALLBASE.DLL (on PC) */
(2)Debug message
(2.1)When I use MS Query to connect to HP, I got error message:
[39]PC Sockets error: 10054. (PCSockets !1).
(2.2)output when I run START ODBCVIEW in ISQL,
I got lots of following error messages:
..........
Number of rows processed is 0
DBEFileSet has no DBEFiles. (DBERR 2501)
..........
(2.3)output from HPDAARLG.PUB.SYS
MON, JUN 5, 1995, 3:56 PM: ***** ALLBASE/NET ARPA LISTENER *****
MON, JUN 5, 1995, 3:56 PM: vclstn: 0
MON, JUN 5, 1995, 3:56 PM: vcaccpt: 0
MON, JUN 5, 1995, 3:56 PM: (warning) VCPeek failed: 30068
MON, JUN 5, 1995, 4:45 PM: vcaccpt: 0
MON, JUN 5, 1995, 4:45 PM: HPDADVR is activated
TUE, JUN 6, 1995, 11:52 AM: ****<- Start of process PIN 334-> ****
TUE, JUN 6, 1995, 11:52 AM: INIT msg received from a PC. SQLX code: 9990
TUE, JUN 6, 1995, 11:52 AM: Sending pc_ack, function code= : 9990,]
TUE, JUN 6, 1995, 11:52 AM:
PC hello msg received, fctcode = 9992, logon = MGR
TUE, JUN 6, 1995, 11:52 AM: Veryfying logon
TUE, JUN 6, 1995, 11:52 AM: logon to parse: MGR.YANG/SESAME95
TUE, JUN 6, 1995, 11:52 AM: Logon = ,MGR.YANG,
TUE, JUN 6, 1995, 11:52 AM: Logon valid
TUE, JUN 6, 1995, 11:52 AM: PC hello msg processing done.
(2.4)output from DrDeeBee
SQLAllocEnv
0x01000000
SQL_SUCCESS
SQLAllocConnect
0x01000000
0x01010000
SQL_SUCCESS
SQLGetInfo
0x01010000
SQL_DRIVER_ODBC_VER
[5]02.00
6
5
SQL_SUCCESS
SQLDriverConnect
0x01010000
0x2405
[9]DSN=sysz1
SQL_NTS
[0]
256
0
SQL_DRIVER_COMPLETE
SQL_ERROR
SQLError
NULL
0x01010000
NULL
[5]S1000
20362
[39]PC Sockets error: 10054. (PCSockets !1)
511
39
SQL_SUCCESS
SQLError
NULL
0x01010000
NULL
[5]00000
20362
[0]
511
0
SQL_NO_DATA_FOUND
SQLFreeConnect
0x01010000
SQL_SUCCESS
SQLFreeEnv
0x01000000
SQL_SUCCESS
Thank You Again!
|