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)
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 |