Restriction value converted to lower case in DDEX provider

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Zhang - 05 Nov 2006 04:21 GMT

I am creating a DDEX provider for Oracle. But I am having some problem
while using the Query designer.

I added a new table into Query designer, but no columns were shown in
the query designer so that I ran the provider in debug mode. I found the
value of first restriction is converted to lower case string when the
collection name is "columns" ( The "Columns" type uses the "GetSchema"
of DbConnection to enumerate). For Oracle, since there is no "Database"
(Catalog) concept, so that the first restriction is schema.

The restriction is in "UPPER" case when the collection name is "Tables".
As well, columns are shown up correctly in the server explorer and
restriction values are kept in upper case when loading columns from the
tree.

I am just having problems with the query designer.

Thanks

Charles Zhang

Reply to this Message

Gary Chang[MSFT] - 06 Nov 2006 08:32 GMT

Hi Charles,

We will perform some research on this issue and reply you as soon as
possible.

Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Gary Chang[MSFT] - 13 Nov 2006 06:28 GMT

Hi Charles,

Does our VSIP specialist contact you offline?

If not, we may need a little more information about the scenario.
Typically when no columns are shown in the query designer it means it was
unable to enumerate columns for the table, which in turn typically means
that the definition of the type concept ¡°TableColumn¡± in the data object
support XML file is incorrect. Would you please send a snippet of his
table and column type definitions from the XML file?

Thanks!

Best regards,

Gary Chang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Charles Zhang - 15 Nov 2006 06:03 GMT

Yes.

Stephen Provine contacted me by email.

Here is the email I sent to him:
"I found the problem. Value of 'DefaultSchema' property of
AdoDotNetDataSourceInformation class was stored in lower case.

The server explorer does not use this property, so that it works fine.
However, the query designer uses this property so that the lower cased
'schema' was passed in."

As for another issue, Stephen Provine told me that:
'Execute Command' and 'Run Stored Procedure' are not available for third
party developer."

Thanks
Charles Zhang

> Hi Charles,
>
[quoted text clipped - 19 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Gary Chang[MSFT] - 15 Nov 2006 10:10 GMT

Thanks for the response, Charles!

Have a nice day!

Best regards,

Gary Chang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Restriction value converted to lower case in DDEX provider

Free Magazines