Problem with OpenSchema

From: Brad Wood (bwood_at_colorflex.com)
Date: 10/23/03


Date: Thu, 23 Oct 2003 13:51:59 -0600

I am trying to use a plain ADO command com object to access the table names
in a SQLServer database using the OpenSchema method. OpenSchema's second
parameter is used to narrow the result set by passing an array of
"constraints." I don't really know where those constraints are defined, but
in VB, this seems to work (according to the newsgroups) if you just need
table names:
OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE"))

When I try what I think would be the Delphi equivalent, it fails with
"Object or provider is not capable of performing requested operation." This
happens when I try to connect to an Access database as well:
OpenSchema(adSchemaTables, VarArrayOf([EmptyParam, EmptyParam, EmptyParam,
'TABLE']), EmptyParam); // third parameter not used

If I don't try to limit my results, it works:
OpenSchema(adSchemaTables, EmptyParam, EmptyParam);

I would like to try the method of limiting my results for more efficiency if
anyone can show me how . . .