How can I fix this problem? "Object reference not set to an instance of an object"

[Naci]

Hi,

I am using .NET 2003. I connect to the SQL Server with SqlConnection class and store table data in a Dataset and display it with DataGrid. My application works very well with my development PC. When I create an executable and install it to other pc’s, I get an error message “Object reference not set to an instance of an object” and no information is displayed in the DataGrid. I get this error message 3 times after installing the application and then system does not display it again.
I do not know how to fix this problem. I would appreciate if you have any idea to fix it.

Naci

[Pirate]

Did you set try catch blocks around your erroneous methods or any code that you suspect it make error ? This will give you -hopefully- more informative error messages .

[Negative0]

I agree with Pirate, from the sound of the error message I would bet that your SQL connection failed.

You need to add more error handling to get a definitive answer.