0
Completed

SQL server "Date" type is not supported?

Kevin Lin 10 years ago updated by anonymous 9 years ago 2

SQL server "Date" type is not supported?

I have one field of type Date in SQL server.

But on import into Identity Broker, using the default field type that is configured for the schema provider (date), validation fails.


DateSQLServerNotSupported.jpg

ConnectorEntityFromDataRowConverter is using the ObjectToValueAdapter to convert to the correct data type. Unfortunately it can only have one converter from .NET DateTime, so it converts to a Timestamp.

The connector schema may be required at this point to then convert to the correct type from the schema.

I've made use of the connector schema, so it's now using the validator for the field to create the correct type. Please confirm.