Sayyiduna Abdullah bin Amr (may Allah be pleased with him) narrates this saying of the Prophet (peace and blessings be upon him): "Whoever becomes intoxicated from wine, his prayer will not be accepted for forty days; and if he dies during that time, he will be like one who worships an idol."
Al-Bazzar recorded it; its chain contains a narrator, Yunus bin Khabbab, and he is da'if (weak).
Hadith Referenceمجمع الزوائد ومنبع الفوائد / كتاب الأشربة / 8186