DbType for Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

using SQL SERVER 2K and VS 2003

my sp takes a text input parameter, but all ofthe character DbType enums
specify a max lenght of 8,000 characters.

What do I use for a Text parameter?
 
rviray;

I must apologize for all the bad names I just called you (I did looked
through the Object browser before posting)... but of course you are right.

Unfortunately I am using the Enterprise Library's DBCommandWrapper
AddOutParameter() method and it calls for a System.Dbtype enum which does not
include Text as an option... strange as it may seem.

On the other hand I can drill down to the wrapped Command Object and create
a proper parameter object and add it to the collection there.

good day...
 
Back
Top