Page 1 of 1

Error while connecting to DB2 through ODBC enterprise stage

Posted: Fri Dec 09, 2011 3:46 am
by snehal15101982
We have migrated to new server and we are facing this issue when run a job (existing jobwhich workes in the old server migrated to new one) we get the below error
main_program: Fatal Error: Could not connect to datasource?? (-1; nbkkdyf; CRD_DFRW; [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Specified security mechanism, (Encrypt Password), is not supported by server.)

Any pointers to resolve this issue is very much appreciated.

Posted: Fri Dec 09, 2011 7:48 am
by qt_ky
Compare the entry for that data source in the .odbc.ini file on the new server to the same entry in the same file on the old server. The file is usually in the path specified by $DSHOME. Telnet to the server and type

echo $DSHOME

or

cat /.dshome

to see the path. Go there and view the .odbc.ini file. Compare the new file to the old file. Under the name of the data source, you'll find one setting per line.