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.
