Sender: jd9@jan.hackit.off
Message-ID: <3806E6E8.C9A01DEE@jan-dittberner.de>
Date: Fri, 15 Oct 1999 08:33:44 +0000
From: Jan Dittberner <jan@jan-dittberner.de>
Organization: TU Dresden - department of computer science
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: unixODBC + PostgreSQL 6.5.1
Content-Type: multipart/mixed; boundary="------------7472499C0E7A9E4E24F333FA"

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

Hello,

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 started isql which failed with the following message:

[jd9@jan jd9]$ isql template1
[ISQL]ERROR: Could not SQLConnect                                               

There are two obscure entries in the logfile:

[ODBC][22911][SQLConnect.c][1378]
                Exit:[SQL_ERROR]
[ODBC][22911][SQLFreeHandle.c][174]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x804c5d8

I used the attached .ini files.

Can someone help?

Jan
-- 
  \___________________________________________________________
Jan Dittberner
Technical University Dresden - department of computer science
--------------------------------------------------------------
mail: jan@jan-dittberner.de
==============================================================
--------------7472499C0E7A9E4E24F333FA
Content-Type: text/plain; charset=iso-8859-1;
 name="odbc.ini"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="odbc.ini"

[PSQL-Test]
Description		= PostgreSQL für DB 'jd9' auf localhost
Driver			= Postgresql
Trace			= Yes
Tracefile		= /tmp/postgresql_proto
Database		= jd9
Host			= localhost
Username		=
Password		=
Port			= 5432
Protocol		= 6.5
ReadOnly		= No
RowVersioning	= No
ShowSystemTables= No
ShowOidColumn	= No
FakeOidIndex	= No
ConnSettings	=

[template1]
Description		= template1
Driver			= postgresql
Trace			= Yes
Tracefile		= /tmp/postgresql.log
Database		= template1
Host			= localhost
Username		=
Password		=
Port			= 5432
Protocol		= 6.4
ReadOnly		= No
RowVersioning		= No
ShowSystemTables	= No
ShowOidColumn		= No
FakeOidIndex		= No
ConnSettings		=

--------------7472499C0E7A9E4E24F333FA
Content-Type: text/plain; charset=us-ascii;
 name="odbcinst.ini"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="odbcinst.ini"

[Postgresql]
Description	= PGSQL 6.5.1
Driver		= /usr/local/lib/libodbcpsql.so.1.0.0
Setup		= /usr/local/lib/libodbcpsqlS.so.1.0.0
FileUsage	= 1
Debug		= 0


--------------7472499C0E7A9E4E24F333FA--