Re: Windows client? - Mailing list pgsql-odbc

From Cedar Cox
Subject Re: Windows client?
Date
Msg-id Pine.LNX.4.21.0202131430140.7886-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Windows client?  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: Windows client?
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: time problem with postgres ODBC driver (fwd)
Next
From: "Mark A. Taff"
Date:
Subject: Re: Windows client?