imagesql user configuration should be as follows:
update user mgr@stock2k to mode=1 (I'm assuming this is the creator and
dba)
add user dstock@stock2k with pass=password (image password for class 15),
mode=1
Adding a user without the pass could be the problem.
http://docs.hp.com/en/36385-90012/ch04s01.html <<imagesql admin manual
Can you provide the error you are getting when connecting with dstock?
try the following if using odbclink/se
1) logon ot dstock.stock2k
2) odbcutse.odbcse.sys 'dstock'
When updating the Creator information , mgr.stock2k do not update the
class. this may cause issues later on.
When adding a user, use the password, not the class. Class does not pass
the password access to sql.
There is a note in the knowledge database (ITRC) JAVA/iX: How to run the
Samples provided with JDBC/iX. Let me know if you can view this
document.this provide same java code for image/sql jdbc connection.
The jdbc driver on the hp3000 is not jdbc 2.0 compliant.
Hope this helps.
Best regards,
Cathlene Mc Rae
HP SR. Response Center Engineer
[log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *