Обсуждение: unixODBC + PostgreSQL 6.5.1

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
==============================================================[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        =
[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

> 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[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