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
|
Список | 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 :
Melanie
...
[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 по дате отправления: