0

Completed

SQL server "Date" type is not supported?

10 years ago • updated by 8 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

Vote

Replies 2
Oldest first
- Newest first
- Oldest first

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.

Reply
|

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.

Reply
|

Customer support service by UserEcho