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

Re: How to configure iodbc access to local postgres db?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Rob Yampolsky <rob(dot)yampolsky(at)encodasystems(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "pgsql-ports(at)postgresql(dot)org" <pgsql-ports(at)postgresql(dot)org>
Subject: Re: How to configure iodbc access to local postgres db?
Date: 2001-04-24 00:15:21
Message-ID: 3AE4C599.80B25A21@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbcpgsql-ports
Rob Yampolsky wrote:
> 
> Told you it was something stupid.  Turns out I was using the wrong
> Postgres ODBC driver.  My MDK 7.2 installation had 2 things that looked
> like the driver.
> 
> /usr/lib/libpsqlodbc.so

This is the driver for iODBC.

> and
> /usr/lib/libodbcpsql.so
> 

This is the driver for unixODBC.

> The correct one seems to be libodbcpsql
> 

You have to choose the driver according to the driver manager.

> I had tried both, and originally using libodbcpsql caused a segmentation
> violation, so I had been concentrating my efforts on the other one.
> 
> Well, I ended up following the setup instructions in the unixODBC package
> documentation to get it working under that package.  Once it worked
> there, I was able to get it working with libiodbc (which my application
> was using).
> 
> Hint- it wants you to specify a UserName in .odbc.ini (you'd think it

Isn't it Username not UserName ?

> would default to the 'current user').
> 

regards,
Hiroshi Inoue

In response to

pgsql-ports by date

Next:From: Jason TishlerDate: 2001-04-24 13:03:50
Subject: Re: Re: [PORTS] Re: initdb problem
Previous:From: Andy SamuelDate: 2001-04-23 21:26:50
Subject: Mandrake 7.2 / 8.0 RPM ?

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-04-24 00:29:33
Subject: Re: Access 2000 - ADO
Previous:From: Hiroshi InoueDate: 2001-04-23 23:54:13
Subject: Re: ODBC on cygwin/NT Postgres 7.1

pgsql-general by date

Next:From: Tom LaneDate: 2001-04-24 00:16:02
Subject: Re: Re: CAST doesn't work
Previous:From: Tom LaneDate: 2001-04-24 00:14:20
Subject: Re: Failed on regression test

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