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.
Error while connecting to DB2 through ODBC enterprise stage
Moderators: chulett, rschirm, roy
-
snehal15101982
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius