pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedunixODBC + PostgreSQL 6.5.1
2+ messages / 2 participants
[nested] [flat]
* unixODBC + PostgreSQL 6.5.1
@ 1999-10-15 08:33 Jan Dittberner <jan@jan-dittberner.de>
1999-10-15 13:58 ` Re: [INTERFACES] unixODBC + PostgreSQL 6.5.1 Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Jan Dittberner @ 1999-10-15 08:33 UTC (permalink / raw)
To: pgsql-interfaces
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
* Re: [INTERFACES] unixODBC + PostgreSQL 6.5.1
1999-10-15 08:33 unixODBC + PostgreSQL 6.5.1 Jan Dittberner <jan@jan-dittberner.de>
@ 1999-10-15 13:58 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Lockhart @ 1999-10-15 13:58 UTC (permalink / raw)
To: Jan Dittberner <jan@jan-dittberner.de>; +Cc: pgsql-interfaces
> 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
Attachments:
.odbc.ini (text/plain, 582B) download
[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
end of thread, other threads:[~1999-10-15 13:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-15 08:33 unixODBC + PostgreSQL 6.5.1 Jan Dittberner <jan@jan-dittberner.de>
1999-10-15 13:58 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
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