Re: [INTERFACES] PostODBC 6.40.0006 to PostgreSQL 6.5.3 read only

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*.