Re: Build and other trouble with 08.03.0100 on Linux - Mailing list pgsql-odbc

From Hiroshi Saito
Subject Re: Build and other trouble with 08.03.0100 on Linux
Date
Msg-id 009101c87ecc$fb552ab0$0301a8c0@HP22720319231
Whole thread Raw
In response to Build and other trouble with 08.03.0100 on Linux  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-odbc
Hi.

FreeBSD of the machine environment which I have does not reproduce a problem.

inet% psql -h localhost
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

saito=# SELECT  ssl_is_used();
 ssl_is_used
-------------
 t
(1 row)

saito=# \q
inet% iodbctest DSN=PostgreSQL
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 08.03.0100 (psqlodbcw.so)

SQL>SELECT  ssl_is_used();

ssl_is_used
-----------
1

 result set 1 returned 1 rows.


SQL>

---

However, It may be that the difference between Linux and something happened the problem.
Therefore, I want to see your log. If possible, please send a log to me.

Regards,
Hiroshi Saito


----- Original Message -----
From: "Bruce McAlister" <bruce.mcalister@blueface.ie>


> I've not been successfull with either 08.02.0500 or 08.03.0100. I posted
> my errors to this list last week. I think we may be experiencing the
> same problem. I'm building on Solaris though. 08.01.0200 works fine for
> me too.
>
> Peter Eisentraut wrote:
>> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to
>> have some open ends.  The default build uses SSL but doesn't link against any
>> SSL library.  Not sure how relevant that is.  But I tried disabling the SSL
>> support using the advertised option --disable-openssl, which doesn't work
>> because the actual option is --disable-usessl.  (Side note: If you want to
>> fix the option name, it might be nice to use --without-openssl to be
>> consistent with PostgreSQL.)  That build then fails because NOT_USE_LIBPQ
>> must be defined.  With a successful build I experience various kinds of
>> problems building up a connection, some of which even go away for a while
>> when I try to connect a few times (!!!).  The driver version 08.01.0200 I
>> have lying around works without problems on the identical configuration
>> (odbcinst.init and odbc.ini).  Is anyone successfully using psqlodbc
>> 08.03.0100 on Unix platforms?
>>
>> --
>> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
>> To make changes to your Subscription:
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc


pgsql-odbc by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Build and other trouble with 08.03.0100 on Linux
Next
From: Jack Wilson
Date:
Subject: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons