Re: IMAGESQL / MB Foster ODBC connectivity problem (278 Views)
Reply
Occasional Visitor
Toby Legg
Posts: 5
Registered: ‎05-29-2001
Message 1 of 3 (278 Views)

IMAGESQL / MB Foster ODBC connectivity problem

I'm running the following versions:

RELEASE: C.65.00 MPE/iX HP31900 C.25.06 USER VERSION: C.65.00

ODBCLink32/SE-32 driver 6.00.00.00 (MB Foster)

(1) I've setup an Image Database for use with IMAGESQL using the following syntax:

:CHGROUP CISPRD
:RUN IMAGESQL.PUB.SYS


HP36385B B.G4.02 IMAGE/SQL Utility MON, APR 16, 2007, 4:32 PM
(C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993

>>SET SQLDBE CIRCDBE
DBE does not exist, do you want to create one? [Y/N] : Y
Creating DBE now ...
>>SET TURBODB DCISDB
>>ATTACH
Split 63 compound source field(s) (ATCWARN 32063).
Mapped 1732 source table/source field name(s) (ATCWARN 32062).
Mapped 15 incompatible/imprecise source type(s) (ATCWARN 32061).
>>DISPLAY USERS

ATTACHED BASES : DCISDB.CISPRD.CIZ
DBEnvironment : CIRCDBE.CISPRD.CIZ
Owner Name : DCISDB

USER LOGON DBOPEN MODE USER PASSWORD USER CLASS
---------- ----------- ------------- ----------

CISMGR.CIZ 5 ; 64
>>EXIT

(2) I streamed ODBCJOB.ODBCSE as MANAGER.SYS.

(4) I can connect the to database in ISQL and I can query the data.

However, when I try to connect via MS Access and ODBC, I get the following error message (see attachment)

It seems like there is some type of time out issue, but I remember in the past when I was using this type functionality with IMAGESQL and ODBC that there were some driver problems with MB Foster and MS Access 2000.

Thanks. Any help is appreciated.
Occasional Visitor
Toby Legg
Posts: 5
Registered: ‎05-29-2001
Message 2 of 3 (278 Views)

Re: IMAGESQL / MB Foster ODBC connectivity problem

I was able to resolve this one myself.

(1) I had to uninstall the current ODBC driver using Control Panel / Add Remove Programs / ODBCLink SE-32.

(2) I then reinstalled it (version 6.00.00.00) with the file attached.

(3) I was able to connect the the database in MS Access, select the files needed, and choose the key to use one of the files. However, when I tried to open it up, I would see a generic SQL error message and the text "#Name?" in all of the cells.

(4) I resolve this by deleting the file TURBOGTX.PUB.SYS using the following syntax:

:FSCHECK.MPEXL.TELESUP
FSCHECK, A.05.00. (C) Hewlett-Packard Co., 1987. All rights reserved.
fscheck: PURGEFILE FILENAME=TURBOGTX.PUB.SYS

TURBOGTX is recreated at the next database access.

Information for the TURBOGTX delete can be found here:

http://raven.utc.edu/cgi-bin/WA.EXE?A2=ind9603D&L=HP3000-L&D=0&T=0&P=18927

(5) I then successfully opened the files in MS Access.
Occasional Visitor
Toby Legg
Posts: 5
Registered: ‎05-29-2001
Message 3 of 3 (278 Views)

Re: IMAGESQL / MB Foster ODBC connectivity problem

Problem solved. See my answers above.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.