varchar(max) problem

[goodarzbabaie]

hi friends.

how to retrieve data from a column in ms sql swerver 2005 with nvarchar(max) data type? i use adodb, also.

my code is here:

$cmd.Parameters.Append($cmd.CreateParameter("@oText", $adNVarCharMax, $adParamOutput, -1, ""))

i equivalent $adNVarCharMax to 202 (NVarChar) and 203 (ntext). but didn;t work.

the return error is:

parameter object is improperly defined

please help.

thanks.

[goodarzbabaie]

hi friends again. the problem solved!!

use SQLNCLI (SQL Native Client) for Proviser stead SQLOLEDB in connectionstring.