Обсуждение: SQLCopyDesc to copy rows between tables

Поиск
Список
Период
Сортировка

SQLCopyDesc to copy rows between tables

От
Przemyslaw Rzepecki
Дата:
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

Re: SQLCopyDesc to copy rows between tables

От
Hiroshi Inoue
Дата:
(2013/11/18 1:25), Przemyslaw Rzepecki wrote:
> 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?

AFAIR SQLCopyDesc has no such functionality.

regards,
Hiroshi Inoue



Re: SQLCopyDesc to copy rows between tables

От
Przemyslaw Rzepecki
Дата:
Thanks for the answer. Is there is list of ODBC3.0 features not
supported by the pgsql-odbc driver?
Regards,
Przemek

On Sat, 2013-11-23 at 18:44 +0900, Hiroshi Inoue wrote:
> AFAIR SQLCopyDesc has no such functionality.
>
> regards,
> Hiroshi Inoue