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

Re: unixODBC again :-(

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Nick Gorham <nick(at)lurcher(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>, PostgreSQL odbc list <pgsql-odbc(at)postgreSQL(dot)org>
Subject: Re: unixODBC again :-(
Date: 2001-01-24 13:50:20
Message-ID: 200101241350.IAA12612@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
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

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-01-24 13:52:13
Subject: Re: PgAccess - small bug?
Previous:From: Bruce MomjianDate: 2001-01-24 13:49:13
Subject: Re: [PATCHES] PgAccess schema-diagram cleanup

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2001-01-24 13:53:15
Subject: Re: unixODBC again :-(
Previous:From: Dave PageDate: 2001-01-24 10:32:06
Subject: ODBC Patch for OJs/Large Querys & Rows

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