connection open problem

Hello,

Hope you would resolved this issue, I am having a similar kind of issue with my application. can you please help me with solution to this.


I am trying to connect to the Database from the application and its not happening at all. The same DLL is working fine in QA and production.

When debugging I understood the SQL connection is always closed.

when I checked the below line of code,

public static SqlConnection objConn = new SqlConnection(strConnStr);

For objConn I was able to see an exception "'ObjConn_serverversion' threw an exception of type System.InvalidOperationException" and the state was CLOSED.

Please let us know whether you can help me with this.

Connection String:


During debug I found the below error message in objConn

Hide   Copy Code

public static SqlConnection objConn = new SqlConnection(strConnStr);

ServerVersion --> 'objConn.ServerVersion' threw an exception of type 'System.InvalidOperationException'

State --> Closed

Source code was initially developed in VS 2008. Now when I opened the solution it automatically takes me to Visual studio 2010 Conversion wizard, I am not sure whether this is something to do with this.

Best and simple way of doing this.

Drag and drop a dropdownlist to the page, click on DataSource property and try to connect to your DB and bind THE control.

You will get the actual connection string.

Hi,
I already tried this.but its not working.
 
 

Can you replace your connection string with this connection string and try.

<appSettings/>
<connectionStrings>
<add name="connWebOrdering" connectionString="Data Source=HorizonDC02;Initial Catalog=test;Integrated Security=True" providerName="System.Data.SqlClient" />
connectionStrings>
 
because it works with integrated security. Just try this once and let me know if its still not works.