From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
---|---|
To: | "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: ODBC DSN Connections |
Date: | 2003-11-04 07:10:46 |
Message-ID: | 6C0CF58A187DA5479245E0830AF84F420AF709@poweredge.attiksystem.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
In Ms-Access, DSN-less connections for pass-through queries, or linked tables work, but I noticed strange problems regarding permissions. The only way to make them work - perfectly! - was to use a DSN. Maybe I'm doing something wrong?
-----Message d'origine-----
De : Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
Envoyé : lundi, 3. novembre 2003 20:57
À : Philippe Lang
Cc : pgsql-odbc(at)postgresql(dot)org
Objet : Re: [ODBC] ODBC DSN Connections
--- Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
wrote:
> Just one quick note, though: My client will be
> implemented with MS Access 2000, and I had a lot of
> problems with permissions and DSN-less connection.
> Permissions simply do not work, at least for me,
> unless I use a good old DSN, with a username and a
> password inside. I use a lot of "Pass-through
> queries" in Access, which are generated dynamically,
> in order to pass parameters to Postgresql, and
> process the results inside a report.
There's nothing to stop you from making a connection
at the time you do your pass-through query, in the
same code. But you would need to hard-code your
connection parameters, or prompt the user for them;
either approach has its drawbacks. Or you could read
the parameters from another location, but that brings
you right back to your DSN idea...
But I agree with you in general, I like the
simplification that DSNs allow. Although I am not
supporting any large number of client installations.
__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Lang | 2003-11-04 07:42:01 | Re: Access, ODBC and "other users" |
Previous Message | Michelle Murrain | 2003-11-04 00:11:12 | Access, ODBC and "other users" |