Re: ODBC 2.0 Bug: wrong timestamp data type

Hi Oleg,

If I provide test drivers, could you it?

regards,
Hiroshi Inoue

On 2018/04/26 1:39, Oleg wrote:
> Hello!
>
>     I used the latest driver version (psqlodbc_10_02_0000-x64.zip).
>     If your application uses ODBC version 2.0. When you call 
> SQLGetTypeInfo, the driver reports supported data types that are not 
> available for version 2.0. The first iteration of the result of this 
> function for the timestamp data type is SQL_TYPE_TIMESTAMP. If you 
> then call SQLBindParameter, ODBC Manager returns s1003 (SQL1).log). 
> The error could be corrected (SQL2.log). To verify this, I made 
> changes to the function PGAPI_GetTypeInfo: for ODBC 2.0 filter 
> unsupported data types.
>
> ---- info.c (1153) ------------------------
> QR_set_field_info_v(res, 18, "INTERVAL_PRECISION", PG_TYPE_INT2, 2);
>
> for (i = 0, sqlType = sqlTypes[0]; sqlType; sqlType = sqlTypes[++i])
> {
> pgType = sqltype_to_pgtype(conn, sqlType);
>
> // Filter unsupported data types
> if (EN_is_odbc2(env) && (sqlType == SQL_TYPE_DATE || sqlType == 
> SQL_TYPE_TIME || sqlType == SQL_TYPE_TIMESTAMP))
> continue;
>
> if (sqlType == SQL_LONGVARBINARY)
> -------------------------------------------
>
>     Thank you for listening.
>
>     WBR,
>     Oleg Tonkikh