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.

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.

---

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.

Great, thanks for the feedback!

---