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