Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


MRomer
2016-08-23T19:34:03Z
I've got a couple of jobs using a database task which executes a stored procedure on MS SQL. On servers where I've upgraded VC to 8.1.2 from an older version, I can set up a Stored Procedure with an XML parameter with no trouble. However, on a machine with 8.1.2 installed as new on it, the XML data type is not available. It's not a showstopper, because I can write SQL to execute the stored procedure from the text tab, but it is annoying that I can't do the same thing in all locations.

When I select the stored procedure and click on "Refresh parameters", I get a popup with the message "Unhandled error occurred while trying to refresh, error: Reqested value 'xml' was not found. If I try to add the parameter manually, XML is not showing in the list of data types.
Sponsor
Forum information
Support
2016-08-24T13:59:25Z
I am not sure I understand. You are talking about the parameters that you set for a stored procedure? The parameters are hard coded and there is no difference if you have upgrade or not. Please supply some screenshots.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
MRomer
2016-08-24T14:32:20Z
While gathering the screenshots to show you, I remembered that a co-worker created the SQL connection on the machine I've been having trouble with. I created a new one and used it, and the Xml data type appeared on the list. I think my co-worker chose the wrong database driver.

Problem solved. Thanks for responding.
Support
2016-08-25T07:43:40Z
Great, thanks for the feedback!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top