This will be due to the user being used to make the connection.
With QlikView it will be using the user account that you are logged onto the machine with. With Qlik Sense it will be the user that the service account is running as.
Either grant your service account rights to the database, or user a saved username and password in the machine ODBC connection.
Hope that helps.
Thank you for the quick reply, in current company we are using sybase database earlier we use connect with odbc with user dsn it is working fine with same userid & password i have checked in db level having permissions for all table even though it throws out with error message as invalid user and password even im trying to create system dsn im failing to create system dsn connection