Re: ODBC problem - Mailing list pgsql-general

From Heiko Klein
Subject Re: ODBC problem
Date
Msg-id 15518.62014.52840.551566@polar.oslo.dnmi.no
Whole thread Raw
In response to Re: ODBC problem  (mark <mark@marklonsdale.co.uk>)
List pgsql-general
Hi,

I don't really understand what you mean by 'tried setting it up ...',
but I asume you meant, you compiled unix-odbc and used my odbc.ini and
odbcinst.ini with pathes changed to your needs.

First step I didn't mention: You need to set up connections via TCP (the
-i switch on startup or change in $PG_DATA/postgresql.conf the
following:
#tcpip_socket = false
tcpip_socket = true


Second step: Make sure libodbc.so is in you LD_LIBRARY_PATH or
/etc/ld.so.conf (on linux).

Third step: put odbc.ini and odbcinst.ini into the $(prefix)/etc
directory

Fourth step: test with isql:   isql DB user
            or     isql DB user password

Fifth step: set up the application you would like to use.

Heiko

mark writes:
 >
 >
 > Hmmmm, tried setting it up the same as yours and still seem to be having
 > the same problems..
 >
 > You mentioned that you were seeing a similar thing.. Was it just
 > changing around the odbc.ini and odbcinst.ini file that changed it , or
 > was there anything else you needed to do ?
 >
 > Thanks for the help..
 >

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Another notify question
Next
From:
Date:
Subject: Re: inheritence behavior question ....