Postgres Pro
Downloads
Home   >   mailing lists

Thread: RE: Re: ODBC Interface questions

RE: Re: ODBC Interface questions

From
Michael Ansley
Date:
Yes, that's true, but I thought that it was installed by default, so it should be there in most cases, and if not, it shouldn't be difficult to get it.
 
MikeA
-----Original Message-----
From: Michael Black [mailto:mblack@distcompsols.com]
Sent: 04 April 2000 12:06
To: Michael Ansley; 'Moray McConnachie'
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Re: ODBC Interface questions

This presumes that the AddIn is installed.
----- Original Message -----
Sent: Tuesday, April 04, 2000 4:46 AM
Subject: RE: [GENERAL] Re: ODBC Interface questions

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
>>