Skip site navigation (1) Skip section navigation (2)

RESOLVED: odbc driver manager and postgresql odbc driver

From: ricardd(at)mathstat(dot)dal(dot)ca
To: "Support for the unixODBC project" <unixodbc-support(at)easysoft(dot)com>,pgsql-odbc(at)postgresql(dot)org
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: RESOLVED: odbc driver manager and postgresql odbc driver
Date: 2006-06-14 22:20:53
Message-ID: 61008. (view raw or whole thread)
Lists: pgsql-odbc
Success. Thanks Josh for the no-nonsense reply.

Basically, I didn't know the location of the appropriate libraries, and I
was confused about all the options available.

I now have the packages "unixodbc-bin" and "odbc-postgresql" installed.
The files /etc/ and /etc/odbcinst.ini are as follows:

Description     = PostgreSQL ODBC driver
Driver          = /usr/lib/odbc/
Setup           = /usr/lib/odbc/
Debug           = 0
CommLog         = 1
UsageCount      = 2

Description           = PostgreSQL ODBC
Driver                = postgreodbc
Trace                 = No
TraceFile             =
Database                = mydatabase
Servername              = localhost
UserName                = postgres
Password                =
Port                    = 5432
Protocol                = 7.0
ReadOnly                = No
RowVersioning           = No
ShowSystemTables        = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =

A final question then, part of the original confusion. Where is the file
"/usr/lib/odbc/" from? It doesn't seem to be from the
odbc-postgresql package:

ricardd(at)octopus:~$ dpkg -L odbc-postgresql

Thanks again.


In response to


pgsql-odbc by date

Next:From: Joshua D. DrakeDate: 2006-06-14 22:26:03
Subject: Re: RESOLVED: odbc driver manager and postgresql odbc driver
Previous:From: Hiroshi InoueDate: 2006-06-14 21:43:15
Subject: Re: Memory Leak ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group