Link to home
Start Free TrialLog in
Avatar of shieldguy
shieldguyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Problem reading the connection string value

I am having problem readig the connection string value

Getting the following error:

"Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.
"
       
           ---- WEB.CONFIG CODE ----
  <connectionStrings>
    <add name="DbConnectionString"
     connectionString="Server=server_name;Database=db_name;User ID=user_id;Password=abc123;Trusted_Connection=False;Max Pool Size=100"
     providerName="System.Data.SqlClient" />
  </connectionStrings>
 
--- ASP.NET CODE ---
 
            Dim conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("DbConnectionString"))
 
sqlComm = New SqlCommand("SELECT * FROM AllOrders WHERE CustomerID = '" & CustomerNo & "'", conn)
 
            conn.Open()
            Dim r As SqlDataReader = sqlComm.ExecuteReader()
            conn.Close()     

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of sityee
sityee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial