OracleDataAdapter

  • Thread starter Thread starter Scott Sosna
  • Start date Start date
S

Scott Sosna

I am using OracleDataAdapter.FillSchema() to get the primary key
information for the table used in the query string assigned to the
command. If the table is referenced directly (such as SELECT * FROM
SCHEMA.TABLE) I get the array of DataColumns in the primary key. If
the table is referenced through synonyms (public or private, such as
SELECT * FROM TABLE where the table is in a different schema) I get no
primary key columns.

..NET Framework 1.0.3705
Microsoft Oracle .NET Data Provider 1.0.0.3328

Using a later version of the .NET Framework is not an option. Thanks.
 
On 28 Aug 2003 05:08:06 -0700, (e-mail address removed) (Scott Sosna) wrote:

¤ I am using OracleDataAdapter.FillSchema() to get the primary key
¤ information for the table used in the query string assigned to the
¤ command. If the table is referenced directly (such as SELECT * FROM
¤ SCHEMA.TABLE) I get the array of DataColumns in the primary key. If
¤ the table is referenced through synonyms (public or private, such as
¤ SELECT * FROM TABLE where the table is in a different schema) I get no
¤ primary key columns.
¤
¤ .NET Framework 1.0.3705
¤ Microsoft Oracle .NET Data Provider 1.0.0.3328
¤
¤ Using a later version of the .NET Framework is not an option. Thanks.

This sounds like a known problem but I believe you have to contact Microsoft PSS for the Oracle .NET
Data Provider 1.1 update/fix.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top