Обсуждение: Re: ODBC Interface questions

I am using the Insight ODBC driver version 6.40.0009 on a Win98 box and
Access 97.
I set it up as a System DNS.  Originally, I linked all the tables with the
Read Only
option checked.  I have since changed this to un-checked.  However, the
tables were still RO.  So I dropped all the links and re-linked them.
I am now able to add or update records in the database.

HTH

"Skelter" <skelter@nospam.full-moon.com> wrote in message
news:Rp9C4.11615$624.1099071@news.flash.net...
> I've been trying to find more information about the ODBC interface for
> POSTGreSQL.
>
> I have Postgresql running on a linux box, and Access97 on an NT box.  I've
> setup the ODBC interface and I can connect, but read-only (yes, I
un-checked
> the read-only box.).
>
> I tried going to the Insight Distributors websight to find more
information.
> The URL given doesn't work, and searches of the sight don't reveal much.
>
> Blach!
>
>
>
>

----- Original Message -----
From: Michael Black <mblack@distcompsols.com>
To: <pgsql-questions@postgresql.org>
Sent: Sunday, April 02, 2000 9:17 PM
Subject: [GENERAL] Re: ODBC Interface questions


> I am using the Insight ODBC driver version 6.40.0009 on a Win98 box and
> Access 97.
> I set it up as a System DNS.  Originally, I linked all the tables with the
> Read Only
> option checked.  I have since changed this to un-checked.  However, the
> tables were still RO.  So I dropped all the links and re-linked them.
> I am now able to add or update records in the database.
>

This is true for all versions of Access, and indeed if you change the port
or the host of your pgsql database, you will similarly need to drop and
relink all tables.

If you turn on in Access the option to view all system tables, and explore a
bit, you will see that the specific ODBC string generated from the DSN is
stored with the table definition.

I believe, though I haven't tried it, that it's possible to rewrite all
these tabledefs just to refer only to the DSN, and omit any specific
references. Going to be slower, though....

Yours,
Moray