I'm trying to use MS ADO 1.5 to connect to the data sources on the HP3000 via ODBCLINK/SE-32. I'm able to connect, but not open data source. My application will just lockup. Here is a portion of my code: Const sADOConnect = "DSN=SFD32;UID=;PWD=;DRIVER={ODBCLink/SE-32 Driver};DATABASE=;" Dim ADORS As New ADODB.Recordset Dim ADOCN As New ADODB.Connection Dim aSQL As String ADOCN.Open (sADOConnect) ADORS.CursorLocation = adUseClient ' I tried this... ADORS.Open "Select * from sfd.BasicTRL", ADOCN, adOpenKeyset, adLockOptimistic ' ...and this ADORS.Open "Select * from BasicTRL", ADOCN, adOpenKeyset, adLockOptimistic upon executing the ADORS.Open... statement the application locks (never returns or times out) Any idea what is happening? Here is a copy of the ODBC log file on the HP. All of this happens and the application still locks. It looks like the HP is finished but the information never makes it back to PC. FYI, I do not have a problem with MS RDO. I do have a need to use MS ADO. 98/05/08 17:10:49 1298 ODBC listener started 98/05/08 17:11:38 1298 Listener created new connection as SYS1 (PIN 1258), 98/05/08 17:11:39 1258 ODBCLNSE E.55.02 started from sockets 98/05/08 17:11:39 1258 Allbase Prepare[49]SELECT NAME, OWNER, TYPE, NPAGES, NROWS FROM CATALOG.TABLE; 98/05/08 17:11:39 1258 Allbase SetParams[49] 98/05/08 17:11:39 1258 Allbase Fetch[49] Rows=200 MaxRows=200 98/05/08 17:11:39 1258 Allbase Fetch[49] Rows=93 MaxRows=200 98/05/08 17:11:40 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:11:40 1258 Allbase Close cursor[49] 98/05/08 17:11:40 1258 Allbase Commit 98/05/08 17:11:40 1258 Allbase Commit 98/05/08 17:11:40 1258 Allbase Prepare[49]SELECT NAME,OWNER,NUMP,NUMR,MULTIRESULT FROM CATALOG.PROCEDURE; 98/05/08 17:11:40 1258 Allbase SetParams[49] 98/05/08 17:11:40 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:11:40 1258 Allbase Close cursor[49] 98/05/08 17:11:40 1258 Allbase Commit 98/05/08 17:11:40 1258 Allbase Commit 98/05/08 17:11:40 1258 User MGR.SFD connected to SFDDBE.DATA.SFD, ClientVer=E.55.02 98/05/08 17:13:07 1258 Prepare[0]Select * from sfd.BasicTRL 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT * FROM SFD.BASICTRL; 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT CONSTRAINTNAME,TYPE FROM CATALOG.CONSTRAINT WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT CONSTRAINTNAME,NUMC,COLNUMS,UNIQUE FROM CATALOG.CONSTRAINTINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT NUMC,NFULL,UNIQUE,COLNUMS FROM CATALOG.HASH WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.INDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.TPINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[49]SELECT INDEXNAME,COLNUMS,UNIQUE FROM CATALOG.IMAGEKEY WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:07 1258 Allbase SetParams[49] 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=1 MaxRows=200 98/05/08 17:13:07 1258 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[49] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:07 1258 Allbase Prepare[0]SELECT * FROM SFD.BASICTRL; 98/05/08 17:13:07 1258 SetParams[0] nparam=0 98/05/08 17:13:07 1258 Allbase SetParams[0] 98/05/08 17:13:07 1258 Allbase Fetch[0] Rows=90 MaxRows=200 98/05/08 17:13:07 1258 Allbase Fetch[0] Rows=0 MaxRows=200 98/05/08 17:13:07 1258 Allbase Close cursor[0] 98/05/08 17:13:07 1258 Allbase Commit 98/05/08 17:13:08 1298 Listener created new connection as SYS2 (PIN 889), 98/05/08 17:13:08 889 ODBCLNSE E.55.02 started from sockets 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT NAME, OWNER, TYPE, NPAGES, NROWS FROM CATALOG.TABLE; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=200 MaxRows=200 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=93 MaxRows=200 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT NAME,OWNER,NUMP,NUMR,MULTIRESULT FROM CATALOG.PROCEDURE; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 User MGR.SFD connected to SFDDBE.DATA.SFD, ClientVer=E.55.02 98/05/08 17:13:08 889 Prepare[0]SELECT * FROM sfd.BasicTRL 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT * FROM SFD.BASICTRL; 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT CONSTRAINTNAME,TYPE FROM CATALOG.CONSTRAINT WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT CONSTRAINTNAME,NUMC,COLNUMS,UNIQUE FROM CATALOG.CONSTRAINTINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT NUMC,NFULL,UNIQUE,COLNUMS FROM CATALOG.HASH WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.INDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.TPINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[49]SELECT INDEXNAME,COLNUMS,UNIQUE FROM CATALOG.IMAGEKEY WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:08 889 Allbase SetParams[49] 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=1 MaxRows=200 98/05/08 17:13:08 889 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:08 889 Allbase Close cursor[49] 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Commit 98/05/08 17:13:08 889 Allbase Prepare[0]SELECT * FROM SFD.BASICTRL; 98/05/08 17:13:09 1298 Listener created new connection as SYS3 (PIN 1636), 98/05/08 17:13:09 1636 ODBCLNSE E.55.02 started from sockets 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT NAME, OWNER, TYPE, NPAGES, NROWS FROM CATALOG.TABLE; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=200 MaxRows=200 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=93 MaxRows=200 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT NAME,OWNER,NUMP,NUMR,MULTIRESULT FROM CATALOG.PROCEDURE; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 User MGR.SFD connected to SFDDBE.DATA.SFD, ClientVer=E.55.02 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT * FROM SFD.BASICTRL; 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT CONSTRAINTNAME,TYPE FROM CATALOG.CONSTRAINT WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT CONSTRAINTNAME,NUMC,COLNUMS,UNIQUE FROM CATALOG.CONSTRAINTINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT NUMC,NFULL,UNIQUE,COLNUMS FROM CATALOG.HASH WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.INDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT INDEXNAME,NUMC,NPAGES,UNIQUE,COLNUMS FROM CATALOG.TPINDEX WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:09 1636 Allbase SetParams[49] 98/05/08 17:13:09 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:09 1636 Allbase Close cursor[49] 98/05/08 17:13:09 1636 Allbase Commit 98/05/08 17:13:09 1636 Allbase Prepare[49]SELECT INDEXNAME,COLNUMS,UNIQUE FROM CATALOG.IMAGEKEY WHERE TABLENAME='BASICTRL ' AND OWNER='SFD '; 98/05/08 17:13:10 1636 Allbase SetParams[49] 98/05/08 17:13:10 1636 Allbase Fetch[49] Rows=1 MaxRows=200 98/05/08 17:13:10 1636 Allbase Fetch[49] Rows=0 MaxRows=200 98/05/08 17:13:10 1636 Allbase Close cursor[49] 98/05/08 17:13:10 1636 Allbase Commit 98/05/08 17:13:10 1636 Allbase Commit 98/05/08 17:13:10 1636 Normal exit, Received 2 requests (130 bytes), Sent 0 records (160 bytes), CPU=0 (93.6%) 98/05/08 17:13:10 889 FreeStmt[0] 98/05/08 17:13:10 889 Allbase Commit 98/05/08 17:13:10 889 Normal exit, Received 2 requests (144 bytes), Sent 0 records (65 bytes), CPU=0 (33.5%) 98/05/08 17:15:56 1258 Normal exit, Received 2 requests (148 bytes), Sent 90 records (3361 bytes), CPU=1 (0.4%) -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading