Databases
Showing results for 
Search instead for 
Do you mean 

IMAGESQL / MB Foster ODBC connectivity problem

Occasional Visitor

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.
2 REPLIES
Occasional Visitor

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

Re: IMAGESQL / MB Foster ODBC connectivity problem

Problem solved. See my answers above.