Attempting to open SQL Connection from console application - conn.open dies

Question

My code gets to conn.Open and gives me "Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.dll"

Here is the block of code:

        _timer.Stop();
        string path = @"C:\testlog.log";
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDB_Conn"].ConnectionString);
        string query = "SELECT RawImportEnabled, ImportDayTimeStamp from Settings";
        SqlCommand cmd = new SqlCommand(query, conn);
        conn.Open(); // Dies here
        SqlDataReader rdr = cmd.ExecuteReader();

Write access to the root will be denied under usual circumstances. — Alex K.
– Alex K., Commented Oct 14, 2016 at 15:42

Syed Mhamudul Hasan · Accepted Answer · 2016-10-14 15:48:09Z

1

Order is missing ...first open connection then use sql command

_timer.Stop();
        string path = @"C:\testlog.log";
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDB_Conn"].ConnectionString);
        conn.Open(); // sholud be here

        string query = "SELECT RawImportEnabled, ImportDayTimeStamp from Settings";
        SqlCommand cmd = new SqlCommand(query, conn);
        SqlDataReader rdr = cmd.ExecuteReader();

Besides your code is not formatted either..Format like this

 string path = @"C:\testlog.log";
            String connectionString = ConfigurationManager.ConnectionStrings["MYDB_Conn"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open(); // sholud be here

                string query = "SELECT RawImportEnabled, ImportDayTimeStamp from Settings";
                SqlCommand cmd = new SqlCommand(query, conn);
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                { 
                    String RawImportEnabled = Convert.ToString(reader["RawImportEnabled"]);
                    //Do some thing
                }
            }

This has some benefits like debugging the connection string by putting a breakpoints ,Disposal of connection without worrying for using statements etc

edited Oct 14, 2016 at 15:48

answered Oct 14, 2016 at 15:42

Syed Mhamudul Hasan

1,3392 gold badges17 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bbcompent1 Over a year ago

Tried modifying the code, still hangs at conn.Open() Let me post modified code as answer so it formats right.

Syed Mhamudul Hasan Over a year ago

Check your connection string with my code by putting a break point and run with debugging

bbcompent1 · Accepted Answer · 2016-10-14 15:54:07Z

0

            _timer.Stop();
        string path = @"C:\testlog.log";
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDB_Conn"].ConnectionString);
        string query = "SELECT RawImportEnabled, ImportDayTimeStamp from Settings";
        conn.Open(); // Dies here again.
        SqlCommand cmd = new SqlCommand(query, conn);

        SqlDataReader rdr = cmd.ExecuteReader();
        if (rdr.HasRows)

answered Oct 14, 2016 at 15:54

bbcompent1

4941 gold badge10 silver badges29 bronze badges

1 Comment

bbcompent1 Over a year ago

Never mind, it is a connection error, cannot use trusted, must use SQL Server Connection User. Thanks all

Collectives™ on Stack Overflow

Attempting to open SQL Connection from console application - conn.open dies

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related