> ----------
> From:         RB[SMTP:RB]
> Sent:         Monday, December 27, 1999 6:47:35 PM
> Subject:      Re: Help trying to connect using ODBC and Win311 to Image DB
> Auto forwarded by a Rule
>
Yes, I read the manual.  Don't fully understand it all since I don't
understand the HP.  The company's IS guy said that he had it set for
Mode 1 and he was trying to make it Mode 5 (maybe the other way
around.  We only had read access, but we were only trying to read).  I
got the feeling he didn't know much about the database itself.

I know absolutely nothing about it.  We are going to give it another
shot shortly.  I am going to take one of my database guys who knows
Access and SQL and see if we can get them to "show us" exactly what
they did in making the database.

I was concerned that the ODBC driver being an SE version may lack
something that we need to fully implement what we are trying to do.  I
can't verify that though.

On 27 Dec 1999 14:56:41 GMT, [log in to unmask] (Birket) wrote:

>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)