Re: Oracle ADO provider does not retrun information for OpenSchema / adSchemaIndexes

• Previous message: Val Mazur: "Re: Advice: closing objects after query in Access DB"
• In reply to: Steve W: "Oracle ADO provider does not retrun information for OpenSchema / adSchemaIndexes"
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 14 May 2004 23:29:10 -0400

Hi Steve,

If OpenSchema method does not return this information, then it means that
provider does not return it as well. Not sure how Oracle built, but I
believe it should have some sort of system tables, which keep this
information. You could query them directly

-- 
Val Mazur
Microsoft MVP
"Steve W" <lsl@btconnect.com.no_spam> wrote in message 
news:%23fn1zEROEHA.1348@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I an using the Oracle ADO provider to connect to an Oracle database.
>
> I use OpenSchema to get back information back about the tables and columns
> within the database - e.g.
>   Set rst = oConnection.OpenSchema(adSchemaTables, Array(Empty, Empty,
> Empty, "table") and
>   Set rstColumns = oConnection.OpenSchema(adSchemaColumns, Array(Empty,
> sSchemaName, sTableName))
>
> But when I try to get index information back via
>    Set rstKeys = oConnection.OpenSchema(adSchemaIndexes, Array(Empty,
> sSchemaName, Empty, Empty, sTableName))
>
> I always get back an empty recordset.
>
>
> Does anyone know if it's possible to get this information ?
>
> TIA
>
> Steve
>
> 

• Previous message: Val Mazur: "Re: Advice: closing objects after query in Access DB"
• In reply to: Steve W: "Oracle ADO provider does not retrun information for OpenSchema / adSchemaIndexes"
• Messages sorted by: [ date ] [ thread ]