From: | "Joseph" <lters(at)mrtc(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: ODBC linked table in access on second pc |
Date: | 2001-02-20 11:56:28 |
Message-ID: | CLEJKCMNOMBPKNIAIODGOEBMCAAA.lters@mrtc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I would turn on logging on your server and see what user name postgres is
getting/seeing.
Is access sending a username from the 'CurrentUser' function, or are you
storing the username in the link information. I have trouble with Access
2000 wanting to store the username in the connection. I don't like that
because I want access to use the 'CurrentUser' variable as the user name for
the postgres connections.
Joseph Showalter
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Stefan Waidele
jun.
Sent: Tuesday, February 20, 2001 4:03 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Re: ODBC linked table in access on second pc
I can backup this report.
At 18:19 16.02.2001 +0200, Carsten Huettl wrote:
>I have a pgsql db (v.6.5.3) with some tables.
same here
>On my pc1 I have created a MS access front end (with ODBC) with
>these
>tables linked.
>When I start the MS access front end from my pc2 (same ODBC
>driver/setup) I get access denied while trying to open the linked
>tables. I can link the tables again from pc2 and open them within the
>same front end.
>This let me open the tables on pc2 but not on pc1. There only works
>the first links.
I was using Delphi 5.0, ODBC, Pg
Worked fine on one PC, didn't work on another with the same settings.
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | ksprague | 2001-02-20 13:55:08 | 7.0.3 on solaris 2.8 |
Previous Message | Stefan Waidele jun. | 2001-02-20 09:06:42 | Re: How do I change data type from text to bool? |