Re: odbc with PostgreSQL 8.0 & Delphi

Поиск
Список
Период
Сортировка
От Melanie Bergeron
Тема Re: odbc with PostgreSQL 8.0 & Delphi
Дата
Msg-id 41581322.9060504@globeecom.com
обсуждение исходный текст
Ответ на Re: odbc with PostgreSQL 8.0 & Delphi  ("Gary Doades" <gpd@gpdnet.co.uk>)
Ответы Re: odbc with PostgreSQL 8.0 & Delphi  ("Gary Doades" <gpd@gpdnet.co.uk>)
Список pgsql-odbc
Дерево обсуждения
Thanks for your reply Gary.  I have ODBC driver psqlodbc-07_03_0200.  I take a look at the mylog file and everything seems to work fine for the query:

...
[2364] Sending SELECT statement on stmt=47094344, cursor_name='SQL_CUR02CE9A48'
[2364]send_query(): conn=47071240, query='SELECT * FROM gec_user_view, gec_domain_view WHERE gec_domain_view.domain_showname = 'GEC' AND gec_domain_view.domain_id = gec_user_view.domain_id AND gec_user_view.login_name = 'mbergeron'
'
[2364]send_query: done sending query
[2364]in QR_Constructor
[2364]exit QR_Constructor
[2364]read 692, global_socket_buffersize=4096
[2364]send_query: got id = 'P'
[2364]send_query: got id = 'T'
[2364]QR_fetch_tuples: cursor = '', self->cursor=0
[2364]num_fields = 22
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='user_id', adtid=23, adtsize=4, atttypmod=-1
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='domain_id', adtid=23, adtsize=4, atttypmod=-1
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='login_name', adtid=1043, adtsize=-1, atttypmod=60
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='login_pass', adtid=1043, adtsize=-1, atttypmod=32
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='first_name', adtid=25, adtsize=-1, atttypmod=-1
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='last_name', adtid=25, adtsize=-1, atttypmod=-1
...
[2364]READING ATTTYPMOD
[2364]CI_read_fields: fieldname='bill_to_user', adtid=16, adtsize=1, atttypmod=-1
[2364]QR_fetch_tuples: past CI_read_fields: num_fields = 22
[2364]MALLOC: tuple_size = 100, size = 17600
[2364]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[2364]qresult: len=1, buffer='2'
[2364]qresult: len=1, buffer='1'
[2364]qresult: len=9, buffer='mbergeron'
[2364]qresult: len=32, buffer='01CFCD4F6B8770FEBFB40CB906715822'
[2364]qresult: len=7, buffer='Melanie'
[2364]qresult: len=8, buffer='Bergeron'
...

But when I am running under Delphi, I can't get any string field like first_name (Melanie); it returns EDatabaseError.  But when I read the log, I see that it was read!

Inside the file, I noticed only one error at the beginning of the 165-page file : 
[4088]PGAPI_Connect: returning...
[4088][SQLGetDiagRecW][4088]PGAPI_GetDiagRec entering rec=1[4088]**** PGAPI_ConnectError: hdbc=47071240 <0>
[4088]enter CC_get_error
[4088]enter CC_create_errormsg
[4088]msg = ''
[4088]exit CC_create_errormsg
[4088]exit CC_get_error
[4088]CC_Get_error returned nothing.
[4088]PGAPI_GetDiagRec exiting 100

Any idea on what my problem could be??

Thanks,

Melanie

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

Предыдущее
От: Shachar Shemesh
Дата:
Сообщение: Re: Hello
Следующее
От: "Gary Doades"
Дата:
Сообщение: Re: odbc with PostgreSQL 8.0 & Delphi