[IBM] [CLI Driver] [Db2/nt] SQL1101N The remote Database "LBZM" on the Node "" cannot be accessed with the specified authorization ID and password. sqlstate=08004

[IBM] [CLI Driver] [Db2/nt]  SQL1101N The remote Database "LBZM" on the Node "" cannot be accessed with the specified authorization ID and password. sqlstate=08004

Best Answer (answer: Pengjianjun, get positive solution in forum http://www.db2china.net/club/index.php ... )
Haha, the problem is very common and the solution is simple:
1, in the sample library to set up the wrapper;
2, in the establishment of the wrapper to establish a server definition, fill in the database to access the cataloged target database name, user name, password;
3. Create user mappings (e.g. db2admin, and fill in the password)
4. Create your nickname (Note that when you click OK, you will be quoted the wrong, you should first in the control center right click on the database TEST, choose to connect the database, input and user mapping the same user name and password after the successful connection, you can create a nickname)

[IBM] [CLI Driver] [Db2/nt] SQL1101N The remote Database "LBZM" on the Node "" cannot be accessed with the specified authorization ID and password. sqlstate=08004