Hi!
When comparing the CRM fields and the fields returned by the ODBC from DEVART and comparing it to DB direct access, I verified that all the fields returned are the same with the exception of the “ownerid$type” field. However, the following fields are missing:
, createdbyyominame
, createdbyname
, createdonbehalfbyyominame
, createdonbehalfbyname
, modifiedbyyominame
, modifiedbyname
,modifiedonbehalfbyyominame
, modifiedonbehalfbyname
, owneridyominame
, owneridname
, owningbusinessunitname
Anyone has experienced this?
Any Fixes?
ODBC Dynamics 365 missing Fields
Re: ODBC Dynamics 365 missing Fields
Hi, I'm experiencing a similar problem - did you find an answer?
When I run a query against a Dynamics table directly in Sql Server Management Studio, with a 'select *', I get the various '...name' fields you mention.
But running it with the Devart ODBC driver in a Linked Server, these fields are not available.
Sometimes, when the 'name' fields are missing, the non-name equivalents have the 'name' content - eg:
So it's all rather perplexing at the moment - we're in our trial period, so not sure we'll be buying this unless we can work around these problems....
When I run a query against a Dynamics table directly in Sql Server Management Studio, with a 'select *', I get the various '...name' fields you mention.
But running it with the Devart ODBC driver in a Linked Server, these fields are not available.
Sometimes, when the 'name' fields are missing, the non-name equivalents have the 'name' content - eg:
- (direct connection) statecode: 1, statecodename: "completed"
(devart) statecode: "completed", statecodename: [not a column]
- (direct connection) ps_caseid: "754974E0-F....", ps_caseidname: "person name - Policy - Oct 29 2018"
(devart) ps_caseid: "754974E0-F....", ps_caseidname: [not a column]
- SELECT TOP 100 * FROM [DynamicsCrmLive]...[some table];
- SELECT TOP 100 * FROM [DynamicsCrmLive]...[some table] ORDER BY something;
So it's all rather perplexing at the moment - we're in our trial period, so not sure we'll be buying this unless we can work around these problems....