Обсуждение: SQLCopyDesc to copy rows between tables
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
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
(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
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