Message-ID: <3919146F.CBE064F1@laserle.fi>
Date: Wed, 10 May 2000 10:49:03 +0300
From: Michael Holopainen <michael@laserle.fi>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Lotus Approach problems, please help meeeeee! ;)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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)