Skip site navigation (1) Skip section navigation (2)

Re: odbc with PostgreSQL 8.0 & Delphi

From: Melanie Bergeron <mbergeron(dot)ssl(at)globeecom(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: odbc with PostgreSQL 8.0 & Delphi
Date: 2004-09-27 13:18:26
Message-ID: 41581322.9060504@globeecom.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-odbc by date

Next:From: Gary DoadesDate: 2004-09-27 17:26:41
Subject: Re: odbc with PostgreSQL 8.0 & Delphi
Previous:From: Shachar ShemeshDate: 2004-09-27 08:24:59
Subject: Re: Hello

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group