Re: ODBC Interface questions

Started by Michael Blackabout 26 years ago5 messagesgeneral

mblack@distcompsols.com

about 26 years ago

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.

Show quoted text

The URL given doesn't work, and searches of the sight don't reveal much.

Blach!

Import Notes

Reference msg id not found: Rp9C4.11615$624.1099071@news.flash.net

Moray McConnachie

moray.mcconnachie@computing-services.oxford.ac.uk

about 26 years ago

In reply to: Michael Black (#1)

Re: Re: ODBC Interface questions

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

Import Notes

Reference msg id not found: Rp9C4.11615$624.1099071@news.flash.net

Michael Ansley

Michael.Ansley@intecsystems.co.uk

about 26 years ago

In reply to: Moray McConnachie (#2)

RE: Re: ODBC Interface questions

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

MikeA

Show quoted text

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

Import Notes

Resolved by subject fallback

Michael Black

mblack@distcompsols.com

about 26 years ago

In reply to: Michael Ansley (#3)

Re: Re: ODBC Interface questions

RE: [GENERAL] Re: ODBC Interface questionsThis presumes that the AddIn is installed.
----- Original Message -----
From: Michael Ansley
To: 'Moray McConnachie' ; Michael Black
Cc: pgsql-general@postgreSQL.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

Show quoted text

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

Michael Ansley

Michael.Ansley@intecsystems.co.uk

about 26 years ago

In reply to: Michael Black (#4)

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@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 -----
From: Michael Ansley <mailto:Michael.Ansley@intecsystems.co.uk>
To: 'Moray <mailto:moray.mcconnachie@computing-services.oxford.ac.uk>
McConnachie' ; Michael Black <mailto:mblack@distcompsols.com>
Cc: pgsql-general@postgreSQL.org <mailto:pgsql-general@postgreSQL.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.mcconnachie@computing-services.oxford.ac.uk

<mailto:moray.mcconnachie@computing-services.oxford.ac.uk> ]

Sent: 03 April 2000 20:11
To: Michael Black
Cc: pgsql-general@postgreSQL.org <mailto:pgsql-general@postgreSQL.org>

Subject: Re: [GENERAL] Re: ODBC Interface questions

----------
From: Moray

McConnachie[ SMTP:MORAY.MCCONNACHIE@COMPUTING-SERVICES.OXFORD.AC.UK

<mailto:SMTP:MORAY.MCCONNACHIE@COMPUTING-SERVICES.OXFORD.AC.UK> ]

Show quoted text

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

Import Notes

Resolved by subject fallback