Click here to Skip to main content
15,902,933 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am getting the following error when I try to run a basic data watching program.

Unhandled Exception: System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
at SqlDependencyTest.Program.Main(String[] args)

Main code

static void Main()
{
Console.WriteLine("Starting Software");//For debug only
SqlDependency.Start(GlobalVars.RS2Events);
Console.WriteLine("Depend Started";);//for debug only

// Registering for changes...
ConnectForChanges();
Console.WriteLine("Registered");//Delete in end
// Only for testing
Console.WriteLine("Make some changes to the Events table.");
Console.WriteLine("Every time a change happens in this ");
Console.WriteLine("program should be notified.\n");
Console.WriteLine("Hit enter to quit this program.");
Console.ReadLine();
// Quitting...
SqlDependency.Stop(GlobalVars.RS2Events);
}

The key in the app.config file

<add key="RS2EDB" value="Data Source=FMVIDSRV1\AIUNIVERSAL;database=AIUEvents_20100318092430;User ID=SCIWatcher;Password=SC1Access;">

The variable in GlobalVars
public static string RS2Events = ConfigurationManager.AppSettings.Get("RS2EDB");


NEED HELP PLEASE
Posted

1 solution

Have you stepped through the debugger ? It's clear from the error that RS2Events is null, so what have you done to either prove the error is wrong, or to confirm that it is the issue and try to solve it ?
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900