From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
---|---|
To: | llestat(at)ibm(dot)net |
Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] Vis Data ODBC |
Date: | 1998-11-09 17:57:11 |
Message-ID: | 36472CF7.512AF611@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1998-11-09 20:27:49 | Re: [INTERFACES] limiting the rows selected in postgresql |
Previous Message | Tom Link | 1998-11-09 16:42:02 | null dates and '?' under pgdbi. |