I am trying to display contents of product description fields which vary in length. Field type is varchar(8000)in SQL Server 7, but ASP only retrieves and displays up to 255 characters.

I have tried the VB 'GetChunk' method, but get "The operation requested by the application is not allowed in this context" error.

Will it work if I change the SQL field data type to Text?

Any other suggestions?