Re: confused about *nix ODBC drivers

On Mon, Oct 30, 2000 at 04:30:49PM +0100, Frank Jördens wrote:
> Currently I am trying to get unixODBC to work, where the

Do you use the graphical frontend to configure it? Should check for some
misconfigurations.

> /usr/local/etc/odbc.ini files looks like:
> 
> [PostgreSQL]
> Description             = Test to Postgres
...

> TraceFile               = sql.log    (what's the absolute path? the user's
> home dir? I don't find an sql.log file anyhwere.)

I'm not sure about this either. How about trying /tmp/sql.log instead?

> Protocol                = 7.1

I'm running version 7.0 and it definitely needs protocol 6.4!

> and /usr/local/etc/odbcinst.ini:
> 
> [PostgreSQL]
> Driver              = /usr/local/pgsql/lib/libpsqlodbc.so
> FileUsage               = 1

I'd recommend trying /usr/lib/libodbcpsql.so as Driver instead. I also had
problems getting unixodbc going with our own odbc driver. If you add a line

Setup           = /usr/lib/libodbcpsqlS.so 

the graphical setup tool will help a lot.

> I could presumably also put in the IP address of some server, which
> would satisfy my requirement - which is to have the client on a
> different box than the server.

Some connections do not work with IP numbers. Did you try a resolvable host
name?

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!