Skip to main content
Solved

Dataverse ODBC Driver - How to select dynamic fields

  • November 5, 2024
  • 4 replies
  • 161 views
D
Forum|alt.badge.img

Hi, I’m confused on how to select the dynamic fields. When I look in the driver ui, I can see the dynamic fields like “createdbyname” which are populated based on the values in “createdby” - but if I try to query using `select createdbyname from account` I get an error: “Query failed: [0x80060888] Could not find a property named ‘createdbyname’ on type ‘Microsoft.Dynamics.CRM.account’”

 

Is there something special I need to do to be able to do this? In TSQL with ssms I can select these fields without issue. Reading through the docs, I don’t see a driver setting that seems like it would enable this feature. Can anyone tell me what I’m missing? 

Best answer by PratikV

@DaveJones4 ,

In order to fix the issue, I have opened up the thread with our engineering team on this and will keep you posted as soon as possible
I appreciate your patience on this.

    This topic has been closed for replies.

    4 replies

    PratikV
    Forum|alt.badge.img
    • PratikV
    • Employee
    • November 6, 2024

    @DaveJones4 , Thanks for reaching out to us.

    As per your query, I ran a similar query on my end and encountered the same error. This suggests there may be an issue within the driver. I’ll conduct additional tests to confirm and keep you updated as soon as possible. Ideally, the query you wrote should retrieve the records without any issues.

      D
      Forum|alt.badge.img
      • DaveJones4
      • Author
      • Collaborator
      • November 6, 2024

      Thanks for the reply, hope we see a fix soon!

      PratikV
      Forum|alt.badge.img
      • PratikV
      • Employee
      • Answer
      • November 7, 2024

      @DaveJones4 ,

      In order to fix the issue, I have opened up the thread with our engineering team on this and will keep you posted as soon as possible
      I appreciate your patience on this.

        PratikV
        Forum|alt.badge.img
        • PratikV
        • Employee
        • November 11, 2024

        @DaveJones4 ,

        The team has fixed the issue and now the driver seems to working fine as expected.
        In order to provide you with an updated build, could you please send mail to [email protected] , so we can share you the updated build of Dataverse ODBC Driver.
        Please add the community URL link of this topic in the mail chain for ease

         

          State of AI Data Connectivity Report: 2026 Outlook
          Terms and ConditionsCookie settingsAccessibility statement