When one works on database migration, one has to think about many things and test carefully. The things that work in previous version, spectacularly fail in the newer version. Why these software are not backward compatible, is beyond this discussion.
For example, when we try to use isql tool to connect to Sybase database server on Sybase 12 version, everything works well.
For example you can use following syntax on Sybase 12 and everything should work ok.
When you use the same syntax while trying to connect to Sybase 15 database server, you will see following error.
The usage of -X parameter in this statement is the culprit. One of the simpler way to resolve this issue is to get rid of -X parameter.
For example, when we try to use isql tool to connect to Sybase database server on Sybase 12 version, everything works well.
For example you can use following syntax on Sybase 12 and everything should work ok.
isql -X -Uusername -Ppassword -w2000 // perform database operations and exit
When you use the same syntax while trying to connect to Sybase 15 database server, you will see following error.
ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED.
The usage of -X parameter in this statement is the culprit. One of the simpler way to resolve this issue is to get rid of -X parameter.
isql -Uusername -Ppassword -Sservername -Ddatabasename -w2000 // perform database operations and exit
No comments:
Post a Comment