From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | linked queries (Access) |
Date: | 2001-03-16 12:55:24 |
Message-ID: | Pine.LNX.4.21.0103161256400.31392-100000@nanu.visionforisrael.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I have come upon a very strange way of doing things. Instead of linking
tables in Access or creating a passthrough query, make a regular select
query with sql like this:
SELECT * FROM tblstusers
IN '' [ODBC;DSN=pgtestdb;UID=cedarc;PWD=mypassword;DATABASE=testdb];
The result is a query through ODBC to PG that you can edit! Perhaps you
could call it a "linked query". Anyway, it does work. It is a bit slower
than using a passthrough query. I'm not sure how it compares to a linked
table. Am I correct in thinking that each query uses a new connection?
Anyone ever done this before? Thoughts / comments?
-Cedar
From | Date | Subject | |
---|---|---|---|
Next Message | Norbert Schollum | 2001-03-16 16:34:23 | Problems with Acess |
Previous Message | Hiroshi Inoue | 2001-03-14 00:30:52 | Re: MULTIBYTE support |