Hi there ~ It is interesting that drinking water but not soda relieves your pain near the right side kidney
area. X-ray may not reveal a kidney stone but a CT scan
may be in order to detect stones or slush that is not detectable by X-ray. I highly recommend that you consult a urologist
to have any doubts regarding pain near the kidney area resolved. Take care and drink plenty of water, if you have no other kidney problems. I hope this helped.