Re: ODBC problem

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