ODBC 2.0 Bug: wrong timestamp data type

From: "Oleg" <tonal(at)aha(dot)ru>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC 2.0 Bug: wrong timestamp data type
Date: 2018-04-25 16:39:13
Message-ID: web-353373047@zbackend1.aha.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Attachment Content-Type Size
SQL1.log application/octet-stream 2.0 KB
SQL2.log application/octet-stream 1.8 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Mahesh Kansara 2018-04-26 03:16:17 PostgreSQL 10 Partition Tables: Support through PG Driver
Previous Message Fernando Luna 2018-04-24 18:47:52 RE: [ODBC] Question regarding accessing only tables to which the user has access