Documentation around Common Problems section

[sgoley]

Is there any preliminary write up around the subsection of the ODBC docs, "Common Problems: To-Do" ?

Link here: https://github.com/Microsoft/DataConnectors/blob/master/docs/odbc.md#common-problems

I'm running into all three of these issues in a custom connector that I don't have the ability to resolve in the driver. As a result, I'm requesting any documentation (including incomplete!) in order to continue making progress.

Two specific cases are:

• "Failed to convert from date to timestamptz for expression "C1". You can override this by using SqlGetInfo for converting from TYPE_DATE to TYPE_TIMESTAMP." (How to make this conversion is currently unspecified in the SqlGetInfo section)

• "Data Type of column payment_type with searchable property UNSEARCHABLE should be SEARCHABLE or ALL_EXCEPT_LIKE." (Text column with custom data type is cast to varchar without searchable flag and is not cast back to custom data type on)

PowerBI Community post here: https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Expression-Error-We-couldn-t-fold-the/m-p/660229/highlight/true#M317083