In article <[log in to unmask]>, Bob Walker <[log in to unmask]> writes: >Try logging on directly to your HP as the user(ODBC.ACCOUNT) >and accessing the DBE and Image table from ISQL. > >This is always as good place to start debugging. > >Bob. > >On 29 Sep 99 at 15:30, Jeff Sullivan wrote: > >> I have setup a special user (odbc.account) for odbclink/se to use as a >> logon for accessing the image database. First I did a newuser ......, >> then in imagesql.pub.sys I did a ADD USER ODBC.ACCOUNT WITH PASS=;, >> MODE=1 >> >> This is also the user defined in the data source (odbclink/se 32 is the >> driver) >> and when I link this into Micosoft Access, everything is OK until I try >> to open >> the data. I get an error that says ODBC-call failed. Invalid >> turboimage database >> access. turboimage intrinisic 401. (dberror 13501). microsoft access >> can't open >> the database in the table view. >> >> Is the user not setup correctly, or what? >> >> any info appreciated. >> >> Jeff Sullivan >> > Jeff and other curious listers ... Another "debugging tool" is ODBCUTSE - The ODBC-UTILITY-for-SE - you will find it in the ODBCLink/SE manual ... it sees if the SQL submitted would work. M$-Access is known as "the client from hell" by the tech team here due to some characteristics it has (caching passwords, unable to handle some of the data types you'd expect it would etc) ... If you would like a class on ODBCLink/SE see the HP site for the HP3000 ... http://www.businessservers.hp.com/ and follow the links to education ... you'll find this ... http://www.hp.com/education/courses/h3223s.html or http://www.hp.com/education/courses/h3231s.html Will give the training you need ... from HP. OR <plug> If you would like a member of the MBFoster team to do a customized class for your team on site - we do do that just drop me a note - many companies have had us do the training they require as we are the lab for the defacto-standard Image/SQL and AllBase/SQL drivers. </plug> Best Regards, Birket PS Here is a quick summary of the 2 HP classes ... BF IMAGE Databases I: TurboIMAGE and IMAGE/SQL (H3223S) This 3-day course teaches database administration, and provides hands-on practice in creating, accessing and maintaining IMAGE databases. Topics: Designing and Creating a TurboIMAGE database Backup and Recovery Security and Multiple User Access Database Logging Installing IMAGE/SQL on a TurboImage database Basic HP Query/3000 and ISQL Commands Database Tools and Utilities IMAGE Databases II: Client/Server Access to IMAGE/SQL (H3231S) This 2-day course provides hands-on practice with the creation of client/server access to IMAGE/SQL databases. Topics: Installing ODBCLink/SE Using IMAGE/SQL as a Back-end for Database Storage Using Microsoft Client Tools to Access IMAGE/SQL Hope it helps ... 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)