Message-Id: <36472CF7.512AF611@insightdist.com>
Date: Mon, 09 Nov 1998 12:57:11 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: llestat@ibm.net
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Vis Data ODBC
References: <98110818262800.00541@linux-serv>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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