Object reference not set to an instance of an object

Question

0.00/5 (No votes)

See more:

Hi, I don't know why I am getting this error when I deploy my web on server. Is it because the problem with my connection string? Please help me. Thank you!!!

Web.config

<add name="Database1" connectionstring="Data Source='170.21.191.85';Initial Catalog='Database1';User ID='sa';Password='123'" />

Login.aspx.vb

VB

Dim connection As String = System.Configuration.ConfigurationManager.ConnectionStrings("Database1").ConnectionString()
    Dim mycon As New SqlConnection(connection)

Posted 24-Feb-11 21:55pm

lowpw

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-02-24T22:01:00

Solution 1

Check your string is in the right place in web.config:

XML

<configuration>
  <connectionStrings>
    <add name=.../>
  </connectionStrings>
...

[edit]Spurious <ConfigSections> removed - I missed the closing tag :-O - OriginalGriff[/edit]

I missed this the first time round: Take the "()" off your Login.aspx.vb:

VB

Dim connection As String = System.Configuration.ConfigurationManager.ConnectionStrings("Database1").ConnectionString()
    Dim mycon As New SqlConnection(connection)

Becomes:

VB

Dim connection As String = System.Configuration.ConfigurationManager.ConnectionStrings("Database1").ConnectionString
Dim mycon As New SqlConnection(connection)

Posted 24-Feb-11 22:01pm

OriginalGriff

Updated 24-Feb-11 22:25pm

v3

Comments

lowpw 25-Feb-11 4:10am

i have error putting it under <configsections>

OriginalGriff 25-Feb-11 4:12am

Sorry? Please try to say that again - I do not understand you.

lowpw 25-Feb-11 4:13am

i have error putting the connectionString under configSections

OriginalGriff 25-Feb-11 4:25am

I missed the closing tag - sorry: Answer updated.

Espen Harlinn 25-Feb-11 10:52am

Seems OP didn't appriciate your efforts, my 5

jayantbramhankar · Answer 2 · 2011-02-24T22:10:00

Solution 3

Correct connectionstring to connectionString

<add name="Database1" connectionstring="Data Source='170.21.191.85';Initial Catalog='Database1';User ID='sa';Password='123'" />

Posted 24-Feb-11 22:10pm

jayantbramhankar

Comments

lowpw 25-Feb-11 4:16am

i still have the error: Object reference not set to an instance of an object