From: "Joseph" <lters@mrtc.com>
To: <pgsql-interfaces@postgresql.org>
Subject: RE: ReadOnly
Date: Wed, 10 Jan 2001 06:53:10 -0500
Message-ID: <LOBBJCNOBBADICNFFOCMMEJCHGAA.lters@mrtc.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <063601c07a55$83e7a8a0$0382a8c0@metavera.com>

What is your end client? Windows or Linux or what?

> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of Tony
> Simopoulos
> Sent: Tuesday, January 09, 2001 11:02 AM
> To: pgsql-interfaces@postgresql.org
> Subject: Fw: [INTERFACES] ReadOnly
> 
> 
> my problem persists .. anybody?!?!?!?!?!?
> 
> > ok,
> >
> > i have finally broken down and decided to ask for some help. i 
> have looked for relevant sections in the manual, scanned previous
> > posts, and searched the entire web for help .. all to no avail.
> >
> > i CANNOT get non-readonly access to pgsql through iODBC on my 
> FreeBSD box.  (from my windows box, this is not a challenge).  when
> i
> > try an update from odbctest i get the following:
> >     [SQLPrepare] Connection is readonly, only select statements 
> are allowed.
> >
> > i have tried almost every permutation i can think of ..  here 
> is my current state.
> >
> > /usr/local/pgsql/odbcinst.ini
> > [PostgreSQL]
> > ReadOnly = 0
> > Debug = 0
> > CommLog = 1
> >
> > /usr/local/etc/odbcinst.ini is identical to this file
> > /etc/odbcinst.ini is identical to this file
> >
> > /usr/local/etc/odbc.ini
> > [ODBC Data Sources]
> > loathe          = PostgreSQL
> > cars            = PostgreSQL
> > foo             = MySQL
> >
> > [Default]
> > Driver          = /usr/local/pgsql/lib/libpsqlodbc.so
> > ReadOnly        = 0
> >
> > [loathe]
> > DSN             = loathe
> > ReadOnly        = 0
> > Driver          = /usr/local/pgsql/lib/libpsqlodbc.so
> > Description     = PGSQL-ODBC
> > Database        = metav
> > Servername      = localhost
> > Port            = 5432
> >
> > $HOME/.odbc.ini is identical to this
> >
> > Most of my resouce problems have to do with contradictions in 
> the descriptions of behaviour of the odbc.ini and odbcinst.ini
> files.
> > there is no clarity that i can find w.r.t. where they should 
> go, when they are accessed, what drivers utilize them (pgsql or iodbc
> > or both??), and what exactly should be in them.
> >
> > someone please help me, before i pull the rest of hair out.
> >
> > thanks,
> >
> > tonys.
> >
> >