How do I retrieve values from a text field in a SQL Server database using ADO?

Question

I'm using a stored procedure to retrieve Notes stored in a text field; not char or varchar, but text is the data type. The records appear correctly if I execute the stored procedure from Query Analyzer. But when I call the procedure from my VB app and I step through the code the same records have the value Empty for the Notes field. How can I get those values to appear in ADO? I tried using the field's GetChunk method, but there's nothing to get. It's really empty.

Thanks

Answer 1

Not sure if you're using ADO.NET or Vb ADO. In any case, this translates into a string. I assume by you using GetChunk you're using .Net. GetChunk is from BLOBS and images, you're only looking to return text. Returning it as a string in your object will due.

MyObject["name"].ToString() will work. If no data is returned then, your database connection or stored procedure is incorrect. Good luck.