From: Byron Nikolaidis <byronn@insightdist.com>
To: llestat@ibm.net
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Vis Data ODBC
Date: Mon, 09 Nov 1998 12:57:11 -0500
Message-ID: <36472CF7.512AF611@insightdist.com> (raw)
References: <98110818262800.00541@linux-serv>
Richard Reyes wrote:
> Hi all hope someone has an answer for me.
>
> I can connect to my database from my Win98 client and view the records but the
> Vis DAta app that comes with VBA complains that its in read only status. I have
> full authority to the database and my hba.conf file is set to trusted. and yes
> I did remove the read only check box from the ODBC driver DSN's.
>
> I'm using debian and one side note I can change and edit in pgaccess,
> I can not connect when I change the auth mode to password or crypt so currently
> I have it set up as trust.
>
I think you need to select a "dynaset" recordset type. The default is snapshot,
which is considered non-updateable by visdata. Look at the left icons on the
toolbar. If that doesn't work, you may also have to turn on the driver option
"Recognize unique indexes".
Byron
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: byronn@insightdist.com, llestat@ibm.net
Subject: Re: [INTERFACES] Vis Data ODBC
In-Reply-To: <36472CF7.512AF611@insightdist.com>
* 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