Hi Mark,

The ExecuteXmlReader is something specific to SQL Server and is not supported on other providers. If you look at the MM OLE DB data access class and look at the ExecXmlReader method you will see how Kevin supports returning an XmlReader object when there is no support for the ExecuteXmlReader method. At this point it does not look like that functionality has been provided because he calls out to a class called mmXmlReader which has no specific code contained in it. It just inherits from the XmlTextReader class. But if you code to this class at least you can get your custom data access class to compile and when the functionality is added, your code will be ready to implement it. I would use that as a guide to how to support Adaptive Server Anywhere. Hope this helps.

>I started creating a MM DataAccess Class for iAnywhere (Sybase) Adaptive Server Anywhere 9.0 by copying the MM DataAccess Class for MS Sql Server and replacing every Sql... by its Asa.. counterpart
>
>( SqlConnection => AsaConnection)
>( SqlTransaction => AsaTransaction)
>etc...
>
>
>public class mmDataAccessAsa : mmDataAccessBase
> {
> protected string PrimaryKeyName = "";
> protected AsaConnection Connection;
> protected AsaTransaction Transaction;
> protected AsaDataAdapter DataAdapter = null;
> private AsaCommandBuilder _commandBuilder = null;
> protected AsaCommandBuilder CommandBuilder
>...
>...
>
>
>This works well for all definitions except for the ExecuteXmlReader method since Adaptive Server Anywhere does not contain a definition for ExecuteXmlReader. So I get the following error message:
>'iAnywhere.Data.AsaClient.AsaCommand' does not contain a definition for 'ExecuteXmlReader'
>
>Any suggestions what I should do?
>
>
>Mark