Problems about ODBC3 datetime

From: "Han" <zhouhanok(at)vip(dot)sina(dot)com>
To: pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
Subject: Problems about ODBC3 datetime
Date: 2002-11-21 06:52:37
Message-ID: 20021121065238.3CE824758FE@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
Firstly, I encountered a problem when using SQL_DATE: when I use SQLGetTypeInfo(...,SQL_DATE);
the API returns no record. I debuged the psqlodbc driver and found that the value of the parameter DataType was 91. So I think that the value was changed by the odbc30 Driver Manager. But why don't the psqlodbc add the SQL_TYPE_DATE and other ODBC30 data types support in the array sqlTypes[](in pgtypes.c)?
Secondly, I wander why returning SQL_DATETIME in function pgtype_to_sqldesctype for the three types--SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP?
Thanks!!!

        

        Han
        zhouhanok(at)vip(dot)sina(dot)com
          2002-11-21

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2002-11-21 13:58:45 empty text on XP in MS Access
Previous Message Hiroshi Inoue 2002-11-21 00:36:33 Re: PostgreSQL+ Beta bug?