From: Andrzej Szydlo <andrzej@gv.edu.pl>
To: Matteo Cavalleri <matteo@bp.lnf.it>
Cc: pgsql-interfaces@hub.org
Subject: Re: ODBC,Delphi and BLOBS
Date: Thu, 20 Aug 1998 16:09:36 +0100
Message-ID: <199808201557.PAA22212@maciek.gv.edu.pl> (raw)
In-Reply-To: <Pine.BSF.3.96.980820150243.21950B-100000@maciek.gv.edu.pl>
On Thu, 20 Aug at 1998 14:34:05 +0200, Matteo Cavalleri wrote:
>
> I am going to use VCL & BDE with PostODBC and PosrgreSQL.
> I have got the same problem when BDE attempts to write a filled blob field
> in the table.
> Do you think that the BOLBs parameter in DBE database configuration cab be
> useful?
I'm not sure how this proprty works, but I don't think it might
influence the BLOB writing problem. Tried different values, anyway,
and it didn't change anything.
> Howewer I have got another problem that may be caused to misconfigurations.
> Simply using a TTable connected to a TDataSource and TDBGrid and loading
> records the refresh is not correct and I need to restart the application in
> order to see all the record in the database.
> Have you got the same problem? Could you please give me your DBE & ODBC &
> TTable configuration parameter?
> How version of PostOdbc & PostgreSQL are you using?
I use PostgreSQL 6.3.2 and PostODBC 0249 - the latest version, with
some extra changes made by Byron.
I don't have any problems with refreshes. Some ODBC drivers cause
such problems, but PostODBC doesn't. My ODBC and
BDE settings are atteched below. I don't change TTable default
settings (obviously except for datasource, table name and indices)
Hope this helps. Let me know if you still have any problems.
Andrzej
++++
ODBC
++++
DSN info: DSN='pgsql
template',server='tech-1',port='5432',dbase='template1',user='postgres
',passwd=''
readonly='0',protocol='',showoid='0',fakeoidindex='0',showsy
stable='0' conn_settings=''
translation_dll='',translation_option=''
conn = 48433276, SQLConnect(DSN='pgsql template', UID='postgres',
PWD='') Global Options: fetch=100, socket=4096, unknown_sizes=2,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=0,
use_declarefetch=0 text_as_longvarchar=0,
unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
+++++++
BDE alias
+++++++
TYPE: PostgreSQL
PATH:
DATABASE NAME:
USER NAME: postgres
ODBC DSN:
OPEN MODE: READ/WRITE
SCHEMA CACHE SIZE: 8
SQLQRYMODE: SERVER
LANGDRIVER:
SQLPASSTHRU MODE: SHARED AUTOCOMMIT
SCHEMA CACHE TIME: -1
MAX ROWS: -1
BATCH COUNT: 200
ENABLE SCHEMA CACHE: FALSE
SCHEMA CACHE DIR:
ENABLE BCD: FALSE
ROWSET SIZE: 20
BLOBS TO CACHE: 64
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: andrzej@gv.edu.pl, matteo@bp.lnf.it, pgsql-interfaces@hub.org
Subject: Re: ODBC,Delphi and BLOBS
In-Reply-To: <199808201557.PAA22212@maciek.gv.edu.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox