Re: odbc with PostgreSQL 8.0 & Delphi

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