Postgres Pro
Downloads
Home   >   mailing lists

SQLCopyDesc to copy rows between tables - Mailing list pgsql-odbc

From Przemyslaw Rzepecki
Subject SQLCopyDesc to copy rows between tables
Date
Msg-id 28C0F92D1CDD9C459B4449A93A77D15C1153FAC3@ESESSMB107.ericsson.se
Whole thread Raw
Responses Re: SQLCopyDesc to copy rows between tables
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: Nick Gorham
Date:
Subject: Re: Is the linking with -lodbc necessary? (--with-odbc)
Next
From: Przemyslaw Rzepecki
Date:
Subject: SQLColAttribute with SQL_DESC_LENGTH for varchar and text types