Unable to adjust BUFFER using setMSSQL function

[johnhyfusion]

Has anyone has success in adjusting the Long Text Buffer size using the
setMSSQL function in the datasource component? It seems as though the only
value which I have been able to programatically change using the setMSSQL
function are the parameters that are of type string. The code below completes
without an error, however the Long Text Buffer field (BUFFER) does not get
updated from the current value of 64000 to the defined 128000. Using the code
below, I can however modify the text fields in the component (i.e. change the
description to 'TESTING 1-2-3').

<cfset
getDSN=createObject("component","cfide.administrat or.components.datasource")>
<cfinvoke component="#getDSN#" method="getDatasource" returnvariable="wpDSN">
<cfinvokeargument name="dsnname" value="LMR">
</cfinvoke>

<cfset myDSN = structNew()>
<cfset myDSN.dsn = "#wpDSN.name#">
<cfset myDSN.host = "#wpDSN.urlmap.host#">
<cfset myDSN.database = "#wpDSN.urlmap.database#">
<cfset myDSN.port = "#wpDSN.urlmap.port#">
<cfset myDSN.driver = "#wpDSN.driver#">
<cfset myDSN.class = "#wpDSN.class#">
<cfset myDSN.username = "#wpDSN.username#">
<cfset myDSN.password = "#wpDSN.password#">
<cfset myDSN.epassword = "#wpDSN.password#">
<cfset myDSN.description = "#wpDSN.description#">
<cfset myDSN.args = "#wpDSN.urlmap.args#">
<cfset myDSN.sendStringParametersAsUnicode =
wpDSN.urlmap.sendStringParametersAsUnicode>
<cfset myDSN.selectmethod = "#wpDSN.urlmap.selectmethod#">
<cfset myDSN.timeout = val(wpDSN.timeout)>
<cfset myDSN.interval = val(wpDSN.interval)>
<cfset myDSN.login_timeout = val(wpDSN.login_timeout)>
<cfset myDSN.buffer = 128000>
<cfset myDSN.blob_buffer = 64000>
<cfset myDSN.pooling = wpDSN.pooling>
<cfset myDSN.disable = wpDSN.disable>
<cfset myDSN.enable_clob = True>
<cfset myDSN.enable_blob = False>
<cfset myDSN.select = wpDSN.select>
<cfset myDSN.create = wpDSN.create>
<cfset myDSN.grant = wpDSN.grant>
<cfset myDSN.insert = wpDSN.insert>
<cfset myDSN.drop = wpDSN.drop>
<cfset myDSN.revoke = wpDSN.revoke>
<cfset myDSN.update = wpDSN.update>
<cfset myDSN.alter = wpDSN.alter>
<cfset myDSN.storedproc = wpDSN.storedproc>
<cfset myDSN.delete = wpDSN.delete>

<cfinvoke component="#getDSN#" method="setMSSQL" returnvariable="wpSetDSN"
argumentcollection="#myDSN#">

[johnhyfusion]

Found it! There is an additional parameter (AdvancedMode, boolean) which needs
to be passed to the DataSource component in order to modify any of the Advanced
Settings. Unfortunately this was not listed in the component browser
documentation.