Problem with backend prepare usin

Поиск
Список
Период
Сортировка
От Wayne Armstrong
Тема Problem with backend prepare usin
Дата
Msg-id 200305241326.h4ODQMbv002011@mail.bacchus.com.au
обсуждение исходный текст
Ответ на Re: slowness in fetch from the psqlodbc driver  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Список pgsql-odbc
Hi,
  I've been trying to get my app to work using the server side prepare option
in the odbc driver.
  I't dies on the first query - with SQLSTATE=07009 - Invalid column number in
DescribeCol. [Native Error=13]]
  The query being issued is :-
'select current_user as x, current_timestamp as y, current_database() as z'.
 The logs from the server look good :-
2003-05-24 23:15:06 [1541]   LOG:  query: BEGIN;PREPARE _PLAN1202048 as select
urrent_user as x, current_timestamp as y, current_database() as z;EXECUTE _PLAN
202048
2003-05-24 23:15:06 [1541]   LOG:  duration: 0.009996 sec
2003-05-24 23:15:06 [1541]   LOG:  query: COMMIT
2003-05-24 23:15:06 [1541]   LOG:  duration: 0.001244 sec

Has anyone tried this? got it to work?
Is it really part of this release (compiled from source current from the cvs as
at 2003-05-24)? or should I just ignore it for now?

Regards,
Wayne


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Fabrizio Mazzoni
Дата:
Сообщение: ODBC 703001 crashes IIS
Следующее
От: Fabrizio Mazzoni
Дата:
Сообщение: ODBC 703001 crashes IIS