Re: Distribution package for OSX - Mailing list pgsql-odbc

On 12/03/2016 09:31 AM, Igor Korot wrote:
> Adrian,
>
> On Sat, Dec 3, 2016 at 12:08 PM, Adrian Klaver
> <adrian.klaver@aklaver.com> wrote:
>> On 12/03/2016 07:57 AM, Igor Korot wrote:
>>>
>>> Adrian,
>>>
>>> On Sat, Dec 3, 2016 at 9:32 AM, Igor Korot <ikorot01@gmail.com> wrote:
>>>>
>>>> Adrian,
>>>>
>>>> On Sat, Dec 3, 2016 at 9:30 AM, Adrian Klaver <adrian.klaver@aklaver.com>
>>>> wrote:
>>>>>
>>>>> On 12/03/2016 06:06 AM, Igor Korot wrote:
>>>>>>
>>>>>>
>>>>>> Michael,
>>>>>>
>>>>>> On Sat, Dec 3, 2016 at 4:03 AM, Michael Paquier
>>>>>> <michael.paquier@gmail.com> wrote:
>>>>>>>
>>>>>>>
>>>>>>> On Sat, Dec 3, 2016 at 12:35 PM, Igor Korot <ikorot01@gmail.com>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>> So which version of the driver I can use?
>>>>>>>> The one that will understand the version I have and successfully can
>>>>>>>> be configured
>>>>>>>> and compiled.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> PQsetSingleRowMode is only available since Postgres 9.2, so you need
>>>>>>> to install a newer version via homebrew or macports.
>>>>>>
>>>>>>
>>>>>>
>>>>>> I don't really care about latest and greatest.
>>>>>> All I need is to test whether I can connect to the PostgreSQL DB thru
>>>>>> the
>>>>>> ODBC
>>>>>> with iODBC on OSX and execute some queries.
>>>>>
>>>>>
>>>>>
>>>>> Got to your other post that mentioned you are using Postgres 9.1.9.
>>>>> So that pushes the psqlodbc version back to psqlodbc-09.00.0310 or
>>>>> older.
>>>
>>>
>>> I successfully compiled and installed the driver in /usr/local/lib.
>>> However, when I tried to run the iODBC Administrator and tried to add
>>> the new DSN
>>> the driver was not available.
>>> Trying to run "ldconfig" I see that this binary is not available.
>>>
>>> I configured the driver with
>>>
>>> [quote]
>>> ../configure --with-odbc=/Library/Framework/iODBC.Framework/iODBC
>>> [/quote]
>>>
>>> Am I missing a configure switch?
>>
>>
>> https://odbc.postgresql.org/docs/unix-compilation.html
>>
>> Should it not be:
>>
>> --with-iodbc=DIR path or direct iodbc-config file
>
> Yes, I gave it a DIR parameter - a directory where iODBC manager is installed.

Yes, but the switch you showed using was:

--with-odbc

not

--with-iodbc

So which one did you use?

You might also want to look in the conf.log to see if there are any
errors reported. Because when I tried with --with-odbc I got at the end
of the ./configure:

configure: WARNING: unrecognized options: --with-odbc

Though make and make install still ran:


aklaver@panda:~/test/psqlodbc-09.05.0300> sudo make install
make[1]: Entering directory '/home/aklaver/test/psqlodbc-09.05.0300'
  /usr/bin/mkdir -p '/usr/local/lib'
  /bin/sh ./libtool   --mode=install /usr/bin/install -c   psqlodbcw.la
'/usr/local/lib'
libtool: install: /usr/bin/install -c .libs/psqlodbcw.so
/usr/local/lib/psqlodbcw.so
libtool: install: /usr/bin/install -c .libs/psqlodbcw.lai
/usr/local/lib/psqlodbcw.la
libtool: finish:

PATH="/usr/local/pgsql/bin:/home/aklaver/.pyenv/shims:/home/aklaver/.pyenv/bin:/usr/local/pgsql/bin:/home/aklaver/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/local/pgsql/include:/usr/local/pgsql/include:/sbin"

ldconfig -n /usr/local/lib
----------------------------------------------------------------------
Libraries have been installed in:
    /usr/local/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
    - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
      during execution
    - add LIBDIR to the `LD_RUN_PATH' environment variable
      during linking
    - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
    - have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
make[1]: Nothing to be done for 'install-data-am'.
make[1]: Leaving directory '/home/aklaver/test/psqlodbc-09.05.0300'



>
> Thank you.
>
>>
>>
>>
>>>
>>> Thank you.
>>>
>>>>
>>>> OK, got it.
>>>> Thx.
>>>>
>>>>>
>>>>>
>>>>>>
>>>>>> Thank you.
>>>>>>
>>>>>>> --
>>>>>>> Michael
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Adrian Klaver
>>>>> adrian.klaver@aklaver.com
>>>
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com