SQLCopyDesc to copy rows between tables

From: Przemyslaw Rzepecki <przemyslaw(dot)rzepecki(at)ericsson(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: SQLCopyDesc to copy rows between tables
Date: 2013-11-17 16:25:16
Message-ID: 28C0F92D1CDD9C459B4449A93A77D15C1153FAC3@ESESSMB107.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I am trying to use SQLCopyDesc function to copy rows between tables. My code
follows example given by MS-DN:
http://msdn.microsoft.com/en-us/library/ms715378%28v=vs.85%29.aspx
(tested also with exactly the example code). With pqsql-odbc driver first call
to SQLCopyDesc fails with error:
SQLCopyDesc: HY000: src descriptor != target type (1)

Is it possible to copy rows between tables without copying data to application
level with pgsql-odbc driver?

Regards,
Przemyslaw

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Przemyslaw Rzepecki 2013-11-20 13:02:01 SQLColAttribute with SQL_DESC_LENGTH for varchar and text types
Previous Message Keri Harris 2013-11-16 20:12:20 Prepared statement with bytea domain cannot be executed with BoolsAsChars=1