Others gathered on the streets, including Wendy Saunders, who drove from Detroit to pay her respects to Houston and said "She meant so much to me," while Renee Taylor, from Baltimore, held a sign, "You gave us more love than we will ever need."
Houston grew up surrounded by gospel and soul music legends like Franklin - who fell ill and was unable to attend the service - as well as Warwick. She later forged new territory for a black female artist who brought R&B and gospel touches into pop music's mainstream.
After her debut, her popularity grew exponentially with her second album, "Whitney" (1987), with all four singles - "Didn't We Almost Have It All," "So Emotional," "Where Do Broken Hearts Go" and "I Wanna Dance with Somebody (Who Loves Me)" - hitting No. 1 on the U.S. Billboard Hot 100 chart.
Her music videos featuring her 1980s style and innocent, fun-loving image made her wildly popular around the world. In "The Bodyguard," with Costner, Houston played a character not far removed from her real self: an international singing sensation coping with fame.
Costner recalled during his speech that Hollywood executives were hesitant to cast Houston in her first starring role, preferring "somebody white," but she soon won everyone over. He also spoke of Houston's immense talent - and insecurities.
"The Whitney that I knew, despite her worldwide success and fame, still wondered, 'Am I good enough, Am I pretty enough, Will they like me?' It was the burden that made her great, and the part that caused her to stumble in the end," he said. "People didn't just like you, Whitney. They loved you."
She made other films, including "The Preacher's Wife," but the 15-year period when she was married to singer Brown coincided with a decline in the quality and frequency of her albums. The couple, who have an 18-year-old daughter, Bobbi Kristina Brown, divorced in 2007.
Houston's powerful voice suffered in recent years. On her last world tour in 2010, she struggled to hit the high notes.
But the service ended by focusing on the old, soaring voice she had promised to reclaim. Her inimitable "I Will Always Love You," rang out as the casket was carried out of the church.
(Additional reporting by Patricia Reaney and Gianna Palmer; editing by Anthony Boadle and Todd Eastham)
3-3