ODBC 2.0 Bug: wrong timestamp data type

"Oleg" <[email protected]>
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <[email protected]>
     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.
SQL1.log (application/octet-stream, 2 KB) - not displayed
SQL2.log (application/octet-stream, 1.8 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.