RE: Re: ODBC Interface questions - Mailing list pgsql-general

From Michael Ansley
Subject RE: Re: ODBC Interface questions
Date
Msg-id 2D50E16224C8D311B183009027452B47449C90@INTEC003
Whole thread Raw
List pgsql-general

Doesn't the linked table manager add-in refresh the tables 'nicely'?

MikeA

>>   -----Original Message-----
>>   From: Moray McConnachie
>>   [mailto:moray.mcconnachie@computing-services.oxford.ac.uk]
>>   Sent: 03 April 2000 20:11
>>   To: Michael Black
>>   Cc: pgsql-general@postgreSQL.org
>>   Subject: Re: [GENERAL] Re: ODBC Interface questions
>>  
>>  
>>  
>>  
>>   > ----------
>>   > From:    Moray
>>   McConnachie[SMTP:MORAY.MCCONNACHIE@COMPUTING-SERVICES.OXFORD.AC.UK]
>>   > Sent:    Monday, April 03, 2000 9:10:30 PM
>>   > To:      Michael Black
>>   > Cc:      pgsql-general@postgreSQL.org
>>   > Subject:         Re: [GENERAL] Re: ODBC Interface questions
>>   > Auto forwarded by a Rule
>>   >
>>   >
>>   ----- 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
>>  

pgsql-general by date:

Previous
From: "Andrew C.R. Martin"
Date:
Subject: Re: [ANNOUNCE] PostgreSQL book completed though chapter 10
Next
From: Peter Eisentraut
Date:
Subject: Re: doing backups