Received: from localhost (IDENT:root@hectic-3.jpl.nasa.gov [128.149.68.205])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA51782
	for <pgsql-interfaces@postgresql.org>;
	Fri, 15 Oct 1999 09:58:49 -0400 (EDT)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1])
	by localhost (8.8.7/8.8.7) with ESMTP id NAA09961;
	Fri, 15 Oct 1999 13:58:45 GMT
Sender: lockhart@hub.org
Message-ID: <38073314.3AE8F67C@alumni.caltech.edu>
Date: Fri, 15 Oct 1999 13:58:44 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Jan Dittberner <jan@jan-dittberner.de>
CC: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] unixODBC + PostgreSQL 6.5.1
References: <3806E6E8.C9A01DEE@jan-dittberner.de>
Content-Type: multipart/mixed; boundary="------------506E5A17073317CDDA6DB6EF"

This is a multi-part message in MIME format.
--------------506E5A17073317CDDA6DB6EF
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> I tried to use unixODBC to connect to a PostgreSQL 6.5.1 DB via
> StarOffice. I couldn't successfully configure odbcinst.ini or
> odbc.ini.

I've had success connecting via Applixware using the included
~/.odbc.ini (note the leading "dot", if that happens to be different
on your system). afaik I do not use any odbcinst.ini file. You might
want to try with a single file at first, until you sort out the
installation.

Good luck.

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California
--------------506E5A17073317CDDA6DB6EF
Content-Type: text/plain; charset=us-ascii;
 name=".odbc.ini"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename=".odbc.ini"

[ODBC Data Sources]
DataEntry = Read/Write Database
QueryOnly = Read-only Database
Test = Debugging Database
Default = Postgres Stripped

[DataEntry]
ReadOnly = 0
Servername = localhost
Database = lockhart

[QueryOnly]
ReadOnly = 1
Servername = localhost
Database = lockhart

[Test]
Debug = 1
CommLog = 1
ReadOnly = 0
Servername = localhost
Username = lockhart
Password = "no$way"
Port = 5432
Database = test
TextAsLongVarchar = 0

[Default]
Servername = localhost
Database = lockhart
Driver = /opt/postgres/current/lib/libpsqlodbc.so

[ODBC]
InstallDir = /opt/applix/axdata/axshlib


--------------506E5A17073317CDDA6DB6EF--