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)
