RE: Re: ODBC Interface questions

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(at)distcompsols(dot)com]
Sent: 04 April 2000 12:06
To: Michael Ansley; 'Moray McConnachie'
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Re: ODBC Interface questions

This presumes that the AddIn is installed.

----- Original Message -----
From: Michael Ansley <mailto:Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk>
To: 'Moray <mailto:moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk>
McConnachie' ; Michael Black <mailto:mblack(at)distcompsols(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org <mailto:pgsql-general(at)postgreSQL(dot)org>
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(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk
<mailto:moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk> ]
>> Sent: 03 April 2000 20:11
>> To: Michael Black
>> Cc: pgsql-general(at)postgreSQL(dot)org <mailto:pgsql-general(at)postgreSQL(dot)org>

>> Subject: Re: [GENERAL] Re: ODBC Interface questions
>>
>>
>>
>>
>> > ----------
>> > From: Moray
>> McConnachie[ SMTP:MORAY(dot)MCCONNACHIE(at)COMPUTING-SERVICES(dot)OXFORD(dot)AC(dot)UK
<mailto:SMTP:MORAY(dot)MCCONNACHIE(at)COMPUTING-SERVICES(dot)OXFORD(dot)AC(dot)UK> ]
>> > Sent: Monday, April 03, 2000 9:10:30 PM
>> > To: Michael Black
>> > Cc: pgsql-general(at)postgreSQL(dot)org
>> > Subject: Re: [GENERAL] Re: ODBC Interface questions
>> > Auto forwarded by a Rule
>> >
>> >
>> ----- Original Message -----
>> From: Michael Black <mblack(at)distcompsols(dot)com>
>> To: <pgsql-questions(at)postgresql(dot)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
>>