pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostODBC 6.40.0006 to PostgreSQL 6.5.3 read only
3+ messages / 3 participants
[nested] [flat]
* PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only
@ 2000-01-10 16:41 Gary Stainburn <gary.stainburn@ringways.co.uk>
2000-01-10 17:10 ` Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Didier Gasser-Morlay <didierg@visualgroup.com>
0 siblings, 1 reply; 3+ messages in thread
From: Gary Stainburn @ 2000-01-10 16:41 UTC (permalink / raw)
To: pgsql-interfaces
Hi all,
I've just downloaded and installed PostODBC, and got it working with MS Excel/MS Query quite easily.
After much messing, which I probably couldn't easily replicate, I got it working with Borland Delphi 3 Professional.
My problems are:
1) I don't know how I got it working and therefore cannot replicate it.
2) Despite having READ/WRITE access in the ODBC, and ReadOnly=False in Delphi, I can only open read-only connections (MS Query is also read-only).
My questions:
1) Does anyone have/know of idiot configuration instructions.
2) Has anyone else had this read-only problem, and if so, how have they got round it?
-----------------------------------------
Gary Stainburn.
Work: http://www.ringways.co.uk mailto:gary.stainburn@ringways.co.uk
REVCOM: http://www.revcom.org.uk mailto:gary.stainburn@revcom.org.uk
-----------------------------------------
If all the world's a stage, does that mean we'll grow out of it?
-----------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only
2000-01-10 16:41 PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Gary Stainburn <gary.stainburn@ringways.co.uk>
@ 2000-01-10 17:10 ` Didier Gasser-Morlay <didierg@visualgroup.com>
2000-01-10 22:16 ` Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Sergio A. Kessler <ser@perio.unlp.edu.ar>
0 siblings, 1 reply; 3+ messages in thread
From: Didier Gasser-Morlay @ 2000-01-10 17:10 UTC (permalink / raw)
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; +Cc: pgsql-interfaces
Gary Stainburn wrote:
>
> Hi all,
>
> I've just downloaded and installed PostODBC, and got it working with MS Excel/MS Query quite easily.
>
> After much messing, which I probably couldn't easily replicate, I got it working with Borland Delphi 3 Professional.
>
> My problems are:
>
> 1) I don't know how I got it working and therefore cannot replicate it.
> 2) Despite having READ/WRITE access in the ODBC, and ReadOnly=False in Delphi, I can only open read-only connections (MS Query is also read-only).
>
> My questions:
> 1) Does anyone have/know of idiot configuration instructions.
1. Install the posDrv.exe (you've done that)
2. in Settings/Control panel/32 bits ODBC click on ADD to create a new
datasource
2.1 choose PostgreSql as the driver click finish
2.2 a new window appears fill i
Datasource: The name you will be presented with when you'll want to use
thais datasourrce
Database/server/username are quite obvious.
(NOTE Make sure that your station is allowed to connect under that
username to PostgreSql (there is a file in the directory where
postgresql stored it's data that you MUST adjust in order to be allowed
to connect to PG. Beware that this file is read-only,m you must Chmod +
to it. )
Click on Options(Advanced) for the datasource and unchecked the
read-only.
this should be it.
HTH
Didier
--
--------------------------------------------------------------------------------------------
Any views or opinions are solely those of the author and do not
necessarily
represent those of Visual Communications Group or its principal
operating
divisions (FPG, Telegraph Colour Library, Planet Earth Pictures,
Colorific!, Pix, Giraudon, Bavaria Bildagentur).
--------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which
it is addressed, and may contain confidential and/or privileged
material.
If you are not the intended recipient of this message, please do not
read,
copy, use or disclose this communication; and please notify the sender
immediately. It should be noted that any review, retransmission,
dissemination or other use of, or taking action in reliance upon, this
information by persons or entities other than the intended recipient is
prohibited.
--------------------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only
2000-01-10 16:41 PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Gary Stainburn <gary.stainburn@ringways.co.uk>
2000-01-10 17:10 ` Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Didier Gasser-Morlay <didierg@visualgroup.com>
@ 2000-01-10 22:16 ` Sergio A. Kessler <ser@perio.unlp.edu.ar>
0 siblings, 0 replies; 3+ messages in thread
From: Sergio A. Kessler @ 2000-01-10 22:16 UTC (permalink / raw)
To: Didier Gasser-Morlay <didierg@visualgroup.com>; +Cc: Gary Stainburn <gary.stainburn@ringways.co.uk>; pgsql-interfaces
Didier Gasser-Morlay wrote:
>
> Gary Stainburn wrote:
> >
> > Hi all,
> >
> > I've just downloaded and installed PostODBC, and got it working with MS Excel/MS Query quite easily.
> >
> > After much messing, which I probably couldn't easily replicate, I got it working with Borland Delphi 3 Professional.
> >
> > My problems are:
> >
> > 1) I don't know how I got it working and therefore cannot replicate it.
> > 2) Despite having READ/WRITE access in the ODBC, and ReadOnly=False in Delphi, I can only open read-only connections (MS Query is also read-only).
>
> >
> > My questions:
> > 1) Does anyone have/know of idiot configuration instructions.
> 1. Install the posDrv.exe (you've done that)
> 2. in Settings/Control panel/32 bits ODBC click on ADD to create a new
> datasource
> 2.1 choose PostgreSql as the driver click finish
> 2.2 a new window appears fill i
>
> Datasource: The name you will be presented with when you'll want to use
> thais datasourrce
> Database/server/username are quite obvious.
> (NOTE Make sure that your station is allowed to connect under that
> username to PostgreSql (there is a file in the directory where
> postgresql stored it's data that you MUST adjust in order to be allowed
> to connect to PG. Beware that this file is read-only,m you must Chmod +
> to it. )
>
> Click on Options(Advanced) for the datasource and unchecked the
> read-only.
>
> this should be it.
note that the last version of the driver is 6.40.0007
^
my settings (also using Delphi):
control-panel -> Odbc -> pick the datasource -> Configure ->
driver ->
Disable Genetic... On
KSQO On
the rest: Off
Unknown Sizes: longest
DataType Options: All checked
and in Datasource, read-only unchecked as Didier say.
and to get rid of BDE, http://perio.unlp.edu.ar/modbc
also is important when installing the postOdbc to install it
with "Install Driver Manager with version checking"
(otherwise it can break your odbc DM if you have a newer version)
I'm using Odbc DM 3.510.4202.0
--
-= Sergio A. Kessler == http://sak.org.ar =-
You can have it soon, cheap and working; choose *two*.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-01-10 22:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-10 16:41 PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only Gary Stainburn <gary.stainburn@ringways.co.uk>
2000-01-10 17:10 ` Didier Gasser-Morlay <didierg@visualgroup.com>
2000-01-10 22:16 ` Sergio A. Kessler <ser@perio.unlp.edu.ar>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox