Thread: Compiling ODBC Applications

Compiling ODBC Applications

From
Dev Kumkar
Date:
Hello,

Can you please provide help on following questions related to compiling ODBC applications on Linux RHEL 5:

1. Which ODBC driver should be downloaded for Linux 64 bit (and also Win 64 bit) for postgres (9.3.4)?

2. Which ODBC developer package should be present when building ODBC applications against postgres ODBC driver? (Shouldn't everything in ODBC header files match with what is in postgres driver .so files?)

3. Is there a postgres specific ODBC developer package (like, say, ‘unixODBC-devel’ rpm you get on Linux)?

4. Is '(int)-1' being returned instead of '(SQLLEN)-1' from SQLGetData for NULL values? If yes then is this by design? On linux 64 bit, observed SQLLEN is not int.

Regards...

Re: Compiling ODBC Applications

From
Adrian Klaver
Date:
On 05/14/2014 10:25 PM, Dev Kumkar wrote:
> Hello,
>
> Can you please provide help on following questions related to compiling
> ODBC applications on Linux RHEL 5:
>
> 1. Which ODBC driver should be downloaded for Linux 64 bit (and also Win
> 64 bit) for postgres (9.3.4)?
>
> 2. Which ODBC developer package should be present when building ODBC
> applications against postgres ODBC driver? (Shouldn't everything in ODBC
> header files match with what is in postgres driver .so files?)
>
> 3. Is there a postgres specific ODBC developer package (like, say,
> ‘unixODBC-devel’ rpm you get on Linux)?
>
> 4. Is '(int)-1' being returned instead of '(SQLLEN)-1' from SQLGetData
> for NULL values? If yes then is this by design? On linux 64 bit,
> observed SQLLEN is not int.
>
> Regards...

A lot of this is answered here:

http://psqlodbc.projects.pgfoundry.org/


--
Adrian Klaver
adrian.klaver@aklaver.com