Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Tarun Kumar 2974 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

Ask by Tarun Kumar

Updated 24 Feb 2016

1 Answers

Uttam Misra 24 Feb 2016 Accepted Answer

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

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

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.