forum

home / developersection / forums / executereader requires an open and available connection. the connection's current state is closed.

ExecuteReader requires an open and available Connection. The connection's current state is closed.

Tarun Kumar 2688 24-Feb-2016

Hi everyone,

When trying to connect to MSSQL Server I am getting following error

ExecuteReader requires an open and available Connection. The connection's current state is closed.

Please help

c# .net sql server sql

Updated on 24-Feb-2016

Tarun Kumar

Other

Follow

Can you answer this question?

1 Answers

24-Feb-2016

I think you forgot to open your connection.
check following line of code:

if (_conn.State == ConnectionState.Closed)
 _conn.Open();
Happy Coding!!!

MindStick Training