Message-ID: <05c801c079af$463fd500$0382a8c0@metavera.com>
From: "Tony Simopoulos" <karkalis@earthling.net>
To: <pgsql-interfaces@postgresql.org>
Subject: ReadOnly
Date: Mon, 8 Jan 2001 15:12:06 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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.