Lotus Approach problems, please help meeeeee! ;)

From: Michael Holopainen <michael(at)laserle(dot)fi>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Lotus Approach problems, please help meeeeee! ;)
Date: 2000-05-10 07:49:03
Message-ID: 3919146F.CBE064F1@laserle.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Problems with Lotus Approach (millenium/9.0) on postgres databases, at
first I could not able the tables at all but then came the windows
postgres ODBC driver 6.40.00.08 and thta enabled me to open the the
tables, but now

postgres 6.5.3 on 2.2.14 kernel (suse6.1) linux as server and NT4 (SP5)
as client with Lotus Smartsuite 9.0

1. The approach automaticly splits datetime to 2 separate field in
display datetime -> DATE | TIME and is unable to alter the data on those
fields.

2. I a simple table I add new row and then start adding values to the
columns I suddently get message "someone has removed the record from
database" and noone else uses the table but me and when I
(refresh-reopen) the record exists ??

here is psqlodbc.log

SN info:
DSN='testname',server='linuxpc',port='5432',dbase='testdb',user='me',passwd=''

readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0008', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=45423208, query=' '
conn=45423208, query='set DateStyle to 'ISO''
conn=45423208, query='set geqo to 'OFF''
conn=45423208, query='set ksqo to 'ON''
conn=45423208, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
...

are there any settings or options that should be on ?

-michael (A)

Browse pgsql-interfaces by date

  From Date Subject
Next Message SAKAIDA Masaaki 2000-05-10 10:53:28 Re: ECPG failed and Postmaster getting bigger in using perl Pg
Previous Message Michael Meskes 2000-05-10 07:45:03 Re: [INTERFACES] Re: looking for doc for ecpg