Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)

Bob Barrows [MVP] wrote:

Pete d'Oronzio [pdmagic] wrote:
Now this is strange. I've just tried this on my work machine and
now get correct results:
ADO Version 2.8
Test dbo TestReport ReportID 3 PKTestConstraint
Test dbo TestReport UserGroupID 1 PKTestConstraint
Test dbo TestReport UserID 2 PKTestConstraint

I have no explanation for this, except that I need to check the
ADO version on my home machine.

Yup - strange.

All of Our test machines both report MDAC 2.8 SP1 (On Windows XP
SP2)

...

So the issue seems to be resolved in SQL 2005.
Can you upgrade to SQL 2005? What SP version of SQL 2000 are you
running? The version at work is SP3a. SP4 is available. Does the
problem occur with SP4? I am unable to test it.

I'll test SP4. However, my app is a commercial app that runs against
many different databases. I don't get to spec that. I think I could
insist that SQL 2000 instances must be fully up to date, but I can't
required 2005.

So - this is not an ADO issue, but a server issue :( I might have to
do a workaround I've been thinking about. Our naming convention uses
"PK" to start all our primary keys. If I count on this, I can use
the Indexes schema information instead of PrimaryKey information.
Feels a bit like a hack, but for SQL 2000, might be the only solution.

Thanks for looking into this. If you find anything else out about
what might be causing it, or a better workaround - I'd be very
interested. Seems odd that the server knows the proper answer, but
gives a wrong answer to ADO. It's not like ADO caches anything,
right? very odd.

-Pete
.

Relevant Pages

  • Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
    ... ADO reports incorrect columns when using OpenSchema( ... Test dbo TestReport UserGroupID 1 PKTestConstraint ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
    ... Test dbo TestReport UserGroupID 1 PKTestConstraint ... I have no explanation for this, except that I need to check the ADO ... my home machine has SQL 2000 on it. ...
    (microsoft.public.data.ado)
  • Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
    ... Test dbo TestReport UserGroupID 1 PKTestConstraint ... Test dbo TestReport UserID 2 PKTestConstraint ... I have no explanation for this, except that I need to check the ADO ...
    (microsoft.public.data.ado)