The connection is already Open (State=Open) 1

[royyan]

I keep on getting "The connection is already Open (State=Open)" error when I trying to set up a site with codes from a book. Could anyone tell me what causes the problem. Many Thanks!

 

[jfrost10]

Could be that the line of code to open a db connection is being executed twice.

If its in the page_load part of a page, make sure its wrapped in a

If Not page.IsPostBack Then

End IF

block

D'Arcy

 

[royyan]

Thank you very much, D'Arcy. Once I added the wrapper to the code, everything is fine now.

 

[jfrost10]

Awesome, glad it worked. And thanks for the star.


D