Обсуждение: Vis Data ODBC

Поиск
Список
Период
Сортировка

Vis Data ODBC

От
Richard Reyes
Дата:
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

Re: [INTERFACES] Vis Data ODBC

От
Byron Nikolaidis
Дата:

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