Ian, I haven't tried this but... I think you can set the DbType to "String" and the Sql provider will work out what you want to do. If you don't specify the Size then the provider should infer it from the value.
Cheers, Nicko > -----Original Message----- > From: Ian Bell [mailto:[EMAIL PROTECTED] > Sent: 27 November 2004 14:36 > To: [email protected] > Subject: DBTypes > > Hi > > Does anyone know how I'd create a sql Text type parameter in > the config section for the ado appender: > > <param name="Parameter"> > <param name="ParameterName" value="@freeFormText" /> > <param name="DbType" value="????" /> > <param name="Size" value="????" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%m" /> > </param> > </param> > > i.e. what would I specify for the type ("Text"?) and size? > > Thanks > > Ian > >
