Jump to content
Sign in to follow this  
goodarzbabaie

varchar(max) problem

Recommended Posts

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.

Share this post


Link to post
Share on other sites
goodarzbabaie

hi friends again. the problem solved!!

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×