Re: unixODBC again :-(

Folks, I need help on this. It would be nice to support unixODBC, but I
don't understand the ramifications of these changes.

> pgman(at)candle(dot)pha(dot)pa(dot)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 install prefix, 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 it provides
> 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 SQLAllocStmt that 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 Windows but 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 country side, 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026