Trouble passing XML string to OpenXML SPROC

[a]

I'm trying to pass an xml file as a variable of type string to an OpenXML
stored procedure, but the code below fails at the "sCmd01.Execute NonQuery();"
line. The SPROC is working fine in Query Analyzer.

Anyone know how to make this work?

Thanks,

Paul

the error code is:
An unhandled exception of type 'System.Data.Sq lClient.SqlExce ption' occurred
in system.data.dll

Additional information: System error.
=============== =============== =============

string XMLDoc = "D:\\SEC\\Progr amming\\SEC DataBots\\SEC DataBot Test
Files\\Form 4\\From QS.xml";
StreamReader srXML = new StreamReader(XM LDoc);
string xmlDoc = srXML.ReadToEnd ();
SqlConnection sCon01 = new
SqlConnection(" server=AMD;Trus ted_Connection= yes;database=My Database");
SqlCommand sCmd01 = new
SqlCommand("_sp _Insert_Form_00 4_XML_template_ 07",sCon01);
sCmd01.CommandT ype = CommandType.Sto redProcedure;
sCmd01.Paramete rs.Add("@Form_0 04",SqlDbType.N Text).Value = xmlDoc;
sCmd01.Connecti on.Open();
sCmd01.ExecuteN onQuery();
sCmd01.Connecti on.Close();

[a]

OK...I didn't validate the test document...it turns out to have an error in it.
The code I've been using is actually ok--except that it needs to also
validate the files.

Paul
---------------------------------------------------------------

"a" wrote:

I'm trying to pass an xml file as a variable of type string to an OpenXML
stored procedure, but the code below fails at the "sCmd01.Execute NonQuery();"
line. The SPROC is working fine in Query Analyzer.

Anyone know how to make this work?

Thanks,

Paul

the error code is:
An unhandled exception of type 'System.Data.Sq lClient.SqlExce ption' occurred
in system.data.dll

Additional information: System error.
=============== =============== =============

string XMLDoc = "D:\\SEC\\Progr amming\\SEC DataBots\\SEC DataBot Test
Files\\Form 4\\From QS.xml";
StreamReader srXML = new StreamReader(XM LDoc);
string xmlDoc = srXML.ReadToEnd ();
SqlConnection sCon01 = new
SqlConnection(" server=AMD;Trus ted_Connection= yes;database=My Database");
SqlCommand sCmd01 = new
SqlCommand("_sp _Insert_Form_00 4_XML_template_ 07",sCon01);
sCmd01.CommandT ype = CommandType.Sto redProcedure;
sCmd01.Paramete rs.Add("@Form_0 04",SqlDbType.N Text).Value = xmlDoc;
sCmd01.Connecti on.Open();
sCmd01.ExecuteN onQuery();
sCmd01.Connecti on.Close();