Error message code 500: Could not execute the specified command: Unknown datatype: unique identifier.

Troubleshooting Editions
, , , ,
1

Example scenario:

declare @id uniqueidentifier   = ‘123’ 
 
SELECT AccountId 
FROM [CData].[dbo].[Test] a 
WHERE a.AccountId = @id

  • The driver is avoiding this process since the conversion is not supported in SQL Server.

  • To address this issue, you will have to use cast to complete the execution. The example scenario should now look like this:

declare @id uniqueidentifier   = ‘123’

SELECT AccountId

FROM [CData].[dbo].[Test] a

WHERE a.AccountId = cast(@id as varchar(255))

24 Likes