Unable to connect to a database in network

Question

1.00/5 (2 votes)

See more:

I have created an application in C# which in working fine on local machince(XP) but when I install that program on network it is unable to connect to database and it throws error:

XML

System.NullReferenceException: Object reference not set to an instance of an object.
   at QualiChem.PartyDetails.PartyDetails_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message&amp; m)
   at System.Windows.Forms.Control.WndProc(Message&amp; m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message&amp; m)
   at System.Windows.Forms.ContainerControl.WndProc(Message&amp; m)
   at System.Windows.Forms.Form.WmShowWindow(Message&amp; m)
   at System.Windows.Forms.Form.WndProc(Message&amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------

I am working in a network of 5 pc interconnected. All pc having windows Xp. What should I do?
Please help.

Posted 3-Aug-10 0:30am

Nikhil Bhivgade

Updated 3-Aug-10 1:24am

Sandeep Mewara

v2

Add a Solution

Comments

Simon_Whale 3-Aug-10 6:35am

With out seeing code, I would suggest that you set a break point and step through your code to see where its falling over.

As something in your partyDetails_Load is not working properly either getting a variable or a variable being set

R. Giskard Reventlov 3-Aug-10 6:48am

Reason for my vote of 1
Cross post: do not ask the same question in 2 forums.

William Winner 3-Aug-10 13:47pm

Where is the database located. My guess is it's on the local machine and needs to be on the network, or if it's on the network, then the other machines may not have mapped the drives with the same drive letter.

3 solutions

Solution 1

Your code is broken because it sucks. Fix your code, so that it's written properly, and this error will never occur. Fix your network permissions or your connection string AFTER you fix your code, no DB error should result in this problem.

Posted 3-Aug-10 0:53am

Christian Graus

Comments

Nikhil Bhivgade 3-Aug-10 7:22am

it work fine on local machine what should i do

Solution 2

Object reference not set to an instance of an object
This error generally occurs when you try to access certain property of an object where objects value is NULL.

Use DEBUGGER and see where is that and handle it. You should be able to do it. Might be in your local system that object has some value but not on server. You need to check and fix that.

Posted 3-Aug-10 1:26am

Sandeep Mewara

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)

Nikhil Bhivgade · Accepted Answer · 2010-08-04T02:26:00

Solution 3

actually i am using integrated security=sspi which is not allowing to do when i am pass user name as password it allowed

i think xp won't allow integrated security over network

Posted 4-Aug-10 2:26am

Nikhil Bhivgade