| Message: 62652 |
 |
BY: Praveen Devarao (praveend)
DATE: 2008-12-01 13:19
SUBJECT: RE: Problems with connection to iseries DB Hi Francesco,
Issue the following command on your client machine to get the list of databases
db2 list db directory
and check what is the authentication type for the AS/400 database that you are connecting to. It will be a type other than SERVER, hence you are not able connect as you could earlier.
Now set the authentication to the one supported by the server (output from command db2 list db directory for the AS/400 database) by issuing the following command
db2 "update cli cfg for section common using Authentication <authentication type>"
With this you will be able to connect to the iseries database using the long form of connection string (that is by specifying the host and port in database.yml). However by having this set the authentication applies to all the connection that you try to make( i.e. for all the uncatalog connection that will be made), which will not be right, since all the databases need not be having the authentication type set to same value.
I will open a defect for the same and provide an option to specify the authentication type in the database.yml, with which users will be able to set the authentication type explicitly. This fix will be available in the next release.
Thanks
Praveen | |
Start New Thread
Problems with connection to iseries DB