SQL Monitor

Topics: User Forum
Jul 19, 2007 at 9:20 PM
Edited Jul 19, 2007 at 9:22 PM
I am trying to set up an SQL Monitor. Here is the template:

<SQLMonitor>
<ConnectionString>Provider=SQLOLEDB;Data Source=testSQL;Initial Catalog=TDB; User ID=userA; Password=P@ssword</ConnectionString>
<SP>
<Name>Get_NumberOfPosts</Name>
</SP>
</SQLMonitor>

I save the monitor and try to test it, but I keep getting this error:
Status: Fail
Status Message: Object reference not set to an instance of an object.

any thoughts?
Coordinator
Jul 24, 2007 at 12:40 PM
You may want to try adding the <Parameters/> node, even if it is empty, right after the </SP> tag. That may be what is causing the problem.
Please let me know if this resolves the problem.Thanks,
Fred.