Simple serialization of an ADO Recordset to XML uses special schemas as you have seen.

To do anything else you have to perform the serialization manually. This is no big deal until you want to use your own (or the stock) schemas. For example nodes of type xsd:dateTime have to be encoded as ISO 8601 date & time strings, and VB6 has no readily available support for doing this (roll your own code).

I'm not even sure what type this element is supposed to be:

<MovieReleaseDate>223467</MovieReleaseDate>

By rights I'd expect xsd:date, but those look like:

2002-09-24
2002-09-24Z
2002-09-24+06:00
etc.