pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Vis Data ODBC
2+ messages / 2 participants
[nested] [flat]

* Vis Data ODBC
@ 1998-11-08 23:21 Richard Reyes <llestat@ibm.net>
  1998-11-09 17:57 ` Re: [INTERFACES] Vis Data ODBC Byron Nikolaidis <byronn@insightdist.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Richard Reyes @ 1998-11-08 23:21 UTC (permalink / raw)
  To: pgsql-interfaces

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.

Any insight is appreciated.

Richard Reyes
llestat@ibm.net



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [INTERFACES] Vis Data ODBC
  1998-11-08 23:21 Vis Data ODBC Richard Reyes <llestat@ibm.net>
@ 1998-11-09 17:57 ` Byron Nikolaidis <byronn@insightdist.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Byron Nikolaidis @ 1998-11-09 17:57 UTC (permalink / raw)
  To: llestat@ibm.net; +Cc: 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







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~1998-11-09 17:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-08 23:21 Vis Data ODBC Richard Reyes <llestat@ibm.net>
1998-11-09 17:57 ` Byron Nikolaidis <byronn@insightdist.com>

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