From: Jan Dittberner <jan@jan-dittberner.de>
To: pgsql-interfaces@postgresql.org
Subject: unixODBC + PostgreSQL 6.5.1
Date: Fri, 15 Oct 1999 08:33:44 +0000
Message-ID: <3806E6E8.C9A01DEE@jan-dittberner.de> (raw)
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
==============================================================
Attachments:odbc.ini (text/plain, 645B) download
[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 =
odbcinst.ini (text/plain, 155B) download
[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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jan@jan-dittberner.de
Subject: Re: unixODBC + PostgreSQL 6.5.1
In-Reply-To: <3806E6E8.C9A01DEE@jan-dittberner.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox