Hello,
this is not a JDBC problem. You have to understand the different kind of users
(DBMUSERs/SQLUSERs) in SAPDB. I think an old mail
(http://listserv.sap.com/pipermail/sapdb.general/2000-November/005793.html) sended
from Bernd Vorsprach will help:
"You have to distinguish between administrative users for the DBM
("DBMUSER") and the ("real") database users for SQL ("SQLUSER").
The SQLUSERs are the users for your database operations via a SQL
interface. The task of this users is to save and find data in the
database. The users are saved inside the database. You can create
and maintain this users via DBM commands ("user_*") with
"SQLUSER=YES". The better way is to create and maintain this users
via a SQL interface with "create user ..." oder "alter user ..."
statements. In this case the DBM don't know this users, but is not
necessary for the DBM to know this users.
The DBMUSERs are saved outside from the database (for OFFLINE use).
You can use this users only to get a DBMServer logon and execute
DBMServer commands. The task of this user is to administrate the
database (start, stop, backup etc.). The SQL interface don't know
them. You can only create and maintain this users via DBMServer
commands."
Regards,
Marco Paskamp
> -----Original Message-----
> From: kenford [mailto:[EMAIL PROTECTED]]
> Sent: Montag, 23. September 2002 03:39
> To: [EMAIL PROTECTED]
> Subject: JDBC Unknown user name/password combination
>
>
>
> Can any one tell me why I am getting this error when trying to connect
> to the server using SAP JDBC. I am able to connect ok with
> SAP Database
> Manager
> using the same user name and password.
>
> I am using the latest Sap DB and JDBC
>
> com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech
> SQL: [-4008]
> Unknown user name/password combination
> at
> com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPa
> cket.java:56)
> ...
> ...
> ...
> ...
>
> Thank you.
>
> kenford
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
