RB -

have you looked at the ODBCLink/SE manual which is available on the web at :
http://jazz.external.hp.com/papers/odbc/index.html

How much do you know about the data you are attempting to access? It sounds
like you weere looking for a view that wasn't there - are you familar with the
the acess that was "granted" by the DBA??

It is not knowing the database you are trying to access that causes grief for
most ODBC users ...

Hope this Helps ... Birket

In article <[log in to unmask]>, RB writes:

>
>First let me say I know nothing about an HP3000.  I work for a company
>that is attempting to integrate our system with theirs using ODBD data
>connectivity.  Our system is running on a Windows 3.11 platform (has
>to run on 3.11 no way around it).
>
>The customer we are trying to connect to is running an HP3000 with an
>Image Database, and is using ODBCLink/SE as the ODBC driver.
>
>The way this works, we map data fields in our program to theirs and
>upon keying in a unique number, our program passes off the number to
>odbc which searches the Image Database and returns fields for our
>program.
>
>We can't get it to work.  We can see the fields of the Image database
>within our program but cannot pull the data in.  We monitored the SQL
>LOG and the following line is seeming to call the problem:
>
> SQLError(0) hdbc=0 hstmt=0 pfNativeError=-1,szErrorMsg=[ODBCLINK
>Host][Allbase]Table/View [log in to unmask] not found.  (DBERR
>2206)
>
>I replaced a lot of the specifics with garbage characters like
>"DDDDDDD" and such above to protect the anonimity of my company as
>well as our customers identity.
>
>I don't have a clue at what to look for.  I will include the whole
>SQL.LOG on this post.
>
>Any suggestions at all would be appreciated.  Again, I don't know
>Image or much about the HP at all, I will print your suggestions and
>work them into a conversation.
>
>If anyone has any ideas and wants to converse one on one via email,
>post an address or something here and I will be glad to reply.  Thanks
>for your time.
>


Birket Foster
M. B. Foster Associates .. the 1-800-ANSWERS people!
Supplying DataExpress w/cross-platform ODBCLink Option (16&32)( 3K,9K&NT)
EC/EDI(3k,9k,NT) Phone (613) 448-2333 or (613) 448-2588 (FAX)
(See our website at WWW.MBFOSTER.COM)