Access can make an interesting environment. If you just want to write SQL
and get a worksheet grid back then it may be the thing for you. Linking
tables is not even necessary. You must, of course, have the PG ODBC
driver installed. Try this (a normal query, not passthrough or anything
special):
SELECT * FROM tblsomething
IN ''
[ODBC;DSN=pgtestdb;DATABASE=testdb;SERVER=nanu;PORT=5432;UID=programmer;PWD=password;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=];
It works in Access 97. I don't know about 2k (let me know if anyone tries
it). Of course, you must change the connect string to your settings (and
change the query to something proper), but the connect string usually
never change, apart from possibly UID and PWD. IIRC, after you create
this you can even use the graphical query builder in Access (with no
linking of tables). The drawback is that I think (IIRC) there is one
connection to the server per query, but shouldn't be a problem if you're
just doing "casual" database work and not building an application. Sorry
if I'm not remembering things correctly.. it's been a while since I've
done Access work.
-Cedar
On Tue, 12 Feb 2002, Laurette Cisneros wrote:
>
> Hi all,
>
> Quick question...any suggested clients that can be used on Windows to
> access a PostgreSQL server on linux (via ODBC)? Mostly for executing SQL
> commands and perhaps other functions?
>
> Thanks,
>
> --
> Laurette Cisneros
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> Passenger Information Everywhere