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.
Thank you.
>
>
>
>>
>> Thank you.
>>
>>>
>>> OK, got it.
>>> Thx.
>>>
>>>>
>>>>
>>>>>
>>>>> Thank you.
>>>>>
>>>>>> --
>>>>>> Michael
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Adrian Klaver
>>>> adrian.klaver@aklaver.com
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com