Are you creating the connection with your ID or with a service account?
Does the account you're using have access? Can you get to the source outside of Qlik?
We had issues initially creating connections. The DBAs gave our service account access but not the individual analysts. We had to log into Qlik as the service account to create some of the connections. Good luck.
First of all thanks for your reply.
I created the odbc connection in qlik sense with the user using qlik sense license, this user is also an windows use who belong to Administrator Group.
I have tested the ODBC connection through the odbc connection tool in windows and the connection test is successfull.
As i wrote in my first post the connection was created successfully for the first time before i deleted it.
Plz advice me.