ConvertToString Method

Converts a Recordset to a MIME string that represents the recordset data.

Syntax

DataFactory.ConvertToString(Recordset)

Applies To

RDSServer.DataFactory

Remarks

With .asp files, use ConvertToString to embed the Recordset on an HTML page generated on the server to transport it to a client computer.

ConvertToString first loads the Recordset into Client Cursor Engine tables, and then generates a stream in MIME format.

On the client, Remote Data Service can convert the MIME string back into a fully functioning Recordset. It works well for handling less than 400 rows of data with no more that 1024 bytes width per row. You shouldn't use it for streaming BLOB data and large result sets over HTTP. No wire compression is performed on the string, so very large data sets will take considerable time to transport over HTTP when compared to the wire-optimized tablegram format defined and deployed by Remote Data Service as its native transport protocol format.

Note If you are using Active Server Pages to embed the resulting MIME string in a client HTML page, note that versions of VBScript earlier than version 2.0 limit the string's size to 32K. If this limit is exceeded, an "Out of string space" error is returned. Keep the query scope relatively small when using MIME embedding via .asp files. To fix this, download the latest version of VBScript from http://www.microsoft.com/vbscript.

Example