From: Tim Bosinius <tim@bosinius.de>
To: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: ODBC & Postgres problem
Date: Mon, 25 May 1998 23:00:35 +0200
Message-ID: <01BD8831.11D74EA0.tim@bosinius.de> (raw)
I am new to this mailing-list and I have a problem with (Insight)ODBC & PostgreSQL.
I have searched the pgsql-interfaces archive to solve my problem but that did not
help me much.
I have installed - following the steps in the INSTALL readme -
postgresql 6.3.2 on my linux (glibc) server
I am trying to access a database I created with InsightDist ODBC and Visual
Basic 5.0 RDO and I have two problems.
First of all postgres uses alot of memory and is really slow, while an ODBC
connection is active:
[postgres@downtown /root]$ ps aux | grep postgres
postgres 19740 0.0 0.5 1420 252 p0 S 20:56 0:00 su postgres
postgres 19741 0.0 1.2 1172 580 p0 S 20:56 0:00 bash
postgres 19746 0.0 0.6 5060 284 p0 S 20:57 0:00 postmaster -i -B 256
postgres 19749 13.2 82.5 56664 38704 p0 S 20:58 0:16 /usr/local/pgsql/bin/postgres -p -Q -P5 -B 256 -v 65536 foo
postgres 19753 0.0 1.0 832 504 p0 R 21:00 0:00 ps aux
postgres 19754 0.0 1.2 1172 580 p0 R 21:00 0:00 bash
[postgres@downtown /root]$
I have 48MB Ram and a big swap, but it uses far too much memory.
The second problem I run into is that when I use RDO or RDC/RDO I cannot activate the
"UseCursor" Option for the ODBC driver and I everytime I try to insert,update or
delete a record I am told that the resultset is writeprotected (Error number 40048)
Can anybody help me one these problems.
Regards,
Tim Bosinius
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: tim@bosinius.de
Subject: Re: ODBC & Postgres problem
In-Reply-To: <01BD8831.11D74EA0.tim@bosinius.de>
* 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