Problem with OpenSchema
From: Brad Wood (bwood_at_colorflex.com)
Date: 10/23/03
- Next message: JLouro: "SQL server DTS"
- Previous message: Perry Way: "Re: Access error message. What does this mean?"
- Next in thread: Brad Wood: "Re: Problem with OpenSchema"
- Reply: Brad Wood: "Re: Problem with OpenSchema"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 . . .
- Next message: JLouro: "SQL server DTS"
- Previous message: Perry Way: "Re: Access error message. What does this mean?"
- Next in thread: Brad Wood: "Re: Problem with OpenSchema"
- Reply: Brad Wood: "Re: Problem with OpenSchema"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]