Re: unixODBC again :-( - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: unixODBC again :-(
Date
Msg-id 200101241350.IAA12612@candle.pha.pa.us
Whole thread Raw
Responses Re: Re: unixODBC again :-(
List pgsql-hackers
Folks, I need help on this.  It would be nice to support unixODBC, but I
don't understand the ramifications of these changes.

> pgman@candle.pha.pa.us wrote:
>
> > Nick, sorry this was never resolved.  Do have any recollection of the
> > issues involved?
>
> Hi Bruce,
>
> Yes I can tell you what I was changing, I would love to get the code in the unixODBC distrib to match the one you
have,or even to remove it 
> and point people to you.
>
> There are a few simple changes.
>
> 1. Add options to use unixODBC in the configure.in file, the mainly consists of finding the root of the unixODBC
installprefix, and adding 
> -I /unixODBC/path/include and -L /unixODBC/path/lib to the driver build
>
> 2. Change the way the driver gets config info, to be the same as when built under windows. link with -lodbcinst and
itprovides 
> SQLGetPrivateProfileString. the code that calls this works as long as the correct define is set.
>
> 3. Stop calling ODBC functions in the driver, this is simple but messy, the problem being the call (say) in
SQLAllocStmtthat calls 
> SQLAllocHandle in the driver, ends up calling the SQLAllocHandle in the driver manager.
>
> There are a couple of other changes I have made, that you may want to add, I added the code to allow encrypted
passwords(taken from the pg 
> lib), as crypt is avaiable on unix. Add the option to detect a server name of localhost, and open the unix domain
socket,in fact try two 
> places, to handle the debian build where the location is different. Again both of these would have no place on
Windowsbut in Unix. 
>
> Its chaos here at the moment, having lost a machine (dead disk) in the move to nice new (old building) offices in the
countryside, but if 
> you want any help, just shout.
>
>
> --
> Nick Gorham
> When I die, I want to go like my grandfather did, gently while sleeping,
> and not like his passangers, screaming in a panic, looking for the
> inflatable raft. -- Seen on ./
>
>
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Small patch to replace 'idle' by 'trans' if transactionis still open
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] select cash_out('2'); crashes backend on 7.0.2