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

Adrian,

On Sat, Dec 3, 2016 at 1:33 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> 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?

That was "--with-iodbc". Sorry for the typo.

Everything ran successfully.

Thank you.

BTW, is there a setup library generated? Maybe that the reason the driver is
not in the list?

>
> 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