How to set ADODB connection property in C#

Question

I'm trying to convert a sample for running a SQL/XML "UpdateGram" from VB to C#.

VB Example:

 conn.Properties("SQLXML Version") = "SQLXML.4.0"

C# Attempts:

 conn.Properties["SQLXML Version"] = "SQLXML.4.0";

Error: cannot be assigned, is read only.

VB Source: https://learn.microsoft.com/en-us/sql/relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/executing-an-updategram-by-using-ado-sqlxml-4-0?view=sql-server-ver15

`conn.Properties["SQLXML Version"].Value = "SQLXML.4.0";`?.. That is literally what is shown in the code samples at your very link. — GSerg, Jun 01 '20 at 15:19
No, but I did see all the `cmd.Properties("Output Stream").Value = strmOut` in the VB blocks. That purple block is the only one to omit the `.Value`. — GSerg, Jun 01 '20 at 15:25

score 3 · Accepted Answer · answered Jun 01 '20 at 15:24

conn.Properties["SQLXML Version"].Value = "SQLXML.4.0";

That is exactly what is shown in the codes samples at that link you've mentioned.

I see where the confusion could have arrived from though, there is a purple "Notes" block that does (erroneously) contain the conn.Properties("SQLXML Version") = "SQLXML.4.0" line. This appears to be a leftover from VB6/A, where parameterless default properties were allowed. They are not allowed in VB.NET, so that line wouldn't work in VB.NET either.

How to set ADODB connection property in C#

1 Answers1