Thread: Distribution package for OSX
Hi, I'm looking for a ready-to-use distribution package of the PostgreSQL ODBC driver for OSX 10.8 (.dmg file). Is it readily available or I will have to build the driver manually? Thank you.
On Fri, Dec 2, 2016 at 5:22 AM, Igor Korot <ikorot01@gmail.com> wrote: > Hi, > I'm looking for a ready-to-use distribution package of the PostgreSQL ODBC > driver for OSX 10.8 (.dmg file). > > Is it readily available or I will have to build the driver manually? You will need to build it manually I am afraid. There are no official packages provided for OSX on odbc.postgresql.org. -- Michael
Hi, Michael, On Thu, Dec 1, 2016 at 8:14 PM, Michael Paquier <michael.paquier@gmail.com> wrote: > On Fri, Dec 2, 2016 at 5:22 AM, Igor Korot <ikorot01@gmail.com> wrote: >> Hi, >> I'm looking for a ready-to-use distribution package of the PostgreSQL ODBC >> driver for OSX 10.8 (.dmg file). >> >> Is it readily available or I will have to build the driver manually? > > You will need to build it manually I am afraid. There are no official > packages provided for OSX on odbc.postgresql.org. This is what I get trying to compile latest source: > Igors-MacBook-Air:buildMac igorkorot$ ../configure > --with-iodbc=/Library/Frameworks/iODBC.framework/iODBC > checking for a BSD-compatible install... /usr/bin/install -c > checking whether build environment is sane... yes > checking for a thread-safe mkdir -p... ../config/install-sh -c -d > checking for gawk... no > checking for mawk... no > checking for nawk... no > checking for awk... awk > checking whether make sets $(MAKE)... yes > checking whether make supports nested variables... yes > checking whether to enable maintainer-specific portions of Makefiles... no > checking for gcc... gcc > checking whether the C compiler works... yes > checking for C compiler default output file name... a.out > checking for suffix of executables... > checking whether we are cross compiling... no > checking for suffix of object files... o > checking whether we are using the GNU C compiler... yes > checking whether gcc accepts -g... yes > checking for gcc option to accept ISO C89... none needed > checking whether gcc understands -c and -o together... yes > checking for style of include used by make... GNU > checking dependency style of gcc... gcc3 > checking -Wall is a valid compile option... yes > ../configure: line 4390: /Library/Frameworks/iODBC.framework/iODBC: > cannot execute binary file > ../configure: line 4393: /Library/Frameworks/iODBC.framework/iODBC: > cannot execute binary file > configure: using > checking last argument to SQLColAttribute is SQLLEN *... yes > checking for pg_config... /usr/bin/pg_config > checking for prove... prove > checking build system type... x86_64-apple-darwin12.5.0 > checking host system type... x86_64-apple-darwin12.5.0 > checking how to print strings... printf > checking for a sed that does not truncate output... /usr/bin/sed > checking for grep that handles long lines and -e... /usr/bin/grep > checking for egrep... /usr/bin/grep -E > checking for fgrep... /usr/bin/grep -F > checking for ld used by gcc... > /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld > checking if the linker > (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld) > is GNU ld... no > checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm > checking the name lister (/usr/bin/nm) interface... BSD nm > checking whether ln -s works... yes > checking the maximum length of command line arguments... 196608 > checking whether the shell understands some XSI constructs... yes > checking whether the shell understands "+="... yes > checking how to convert x86_64-apple-darwin12.5.0 file names to > x86_64-apple-darwin12.5.0 format... func_convert_file_noop > checking how to convert x86_64-apple-darwin12.5.0 file names to > toolchain format... func_convert_file_noop > checking for /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld > option to reload object files... -r > checking for objdump... objdump > checking how to recognize dependent libraries... pass_all > checking for dlltool... dlltool > checking how to associate runtime and link libraries... printf %s\n > checking for ar... ar > checking for archiver @FILE support... no > checking for strip... strip > checking for ranlib... ranlib > checking command to parse /usr/bin/nm output from gcc object... ok > checking for sysroot... no > checking for mt... no > checking if : is a manifest tool... no > checking for dsymutil... dsymutil > checking for nmedit... nmedit > checking for lipo... lipo > checking for otool... otool > checking for otool64... no > checking for -single_module linker flag... yes > checking for -exported_symbols_list linker flag... yes > checking for -force_load linker flag... yes > checking how to run the C preprocessor... gcc -E > checking for ANSI C header files... yes > checking for sys/types.h... yes > checking for sys/stat.h... yes > checking for stdlib.h... yes > checking for string.h... yes > checking for memory.h... yes > checking for strings.h... yes > checking for inttypes.h... yes > checking for stdint.h... yes > checking for unistd.h... yes > checking for dlfcn.h... yes > checking for objdir... .libs > checking if gcc supports -fno-rtti -fno-exceptions... yes > checking for gcc option to produce PIC... -fno-common -DPIC > checking if gcc PIC flag -fno-common -DPIC works... yes > checking if gcc static flag -static works... no > checking if gcc supports -c -o file.o... yes > checking if gcc supports -c -o file.o... (cached) yes > checking whether the gcc linker > (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld) > supports shared libraries... yes > checking dynamic linker characteristics... darwin12.5.0 dyld > checking how to hardcode library paths into programs... immediate > checking for dlopen in -ldl... yes > checking whether a program can dlopen itself... yes > checking whether a statically linked program can dlopen itself... yes > checking whether stripping libraries is possible... yes > checking if libtool supports shared libraries... yes > checking whether to build shared libraries... yes > checking whether to build static libraries... no > checking for library containing SQLGetPrivateProfileString... -liodbcinst > checking for pthread_create in -lpthreads... no > checking for pthread_create in -lpthread... yes > checking for PQsetSingleRowMode in -lpq... no > configure: error: libpq library version >= 9.2 is required > [/code] As I said I have 10.8 that was orinally installed on the system. And I will try to connect to 9.5.2 which is running on Linux. Do you know which driver version I should use? Thank you. > -- > Michael
Igor Korot <ikorot01@gmail.com> writes:
> This is what I get trying to compile latest source:
>> checking for PQsetSingleRowMode in -lpq... no
>> configure: error: libpq library version >= 9.2 is required
Apple does ship a copy of libpq in /usr/lib, but it's generally a bit
back-rev, and you're working in a macOS release that's itself several
years out of date. You'll need to install a newer libpq to satisfy this
ODBC version, evidently.
There isn't any separate distribution of libpq alone; you need to
build and install all of Postgres into, say, /usr/local. That's
not hard, but if you don't enjoy rolling it all yourself, you might
want to consider installing from MacPorts or Homebrew.
regards, tom lane
Hi, Tom, On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Igor Korot <ikorot01@gmail.com> writes: >> This is what I get trying to compile latest source: > >>> checking for PQsetSingleRowMode in -lpq... no >>> configure: error: libpq library version >= 9.2 is required > > Apple does ship a copy of libpq in /usr/lib, but it's generally a bit > back-rev, and you're working in a macOS release that's itself several > years out of date. You'll need to install a newer libpq to satisfy this > ODBC version, evidently. Is there a way to see what version of PostgreSQL is installed on the system? Because then it would be easy to find out what version of ODBC driver I should have to connect. Or maybe I already have the driver, since I have iODBC installed? Just checked - driver is not there. Thank you. > > There isn't any separate distribution of libpq alone; you need to > build and install all of Postgres into, say, /usr/local. That's > not hard, but if you don't enjoy rolling it all yourself, you might > want to consider installing from MacPorts or Homebrew. > > regards, tom lane
On Fri, Dec 2, 2016 at 1:47 PM, Igor Korot <ikorot01@gmail.com> wrote: > Hi, Tom, > > On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Igor Korot <ikorot01@gmail.com> writes: >>> This is what I get trying to compile latest source: >> >>>> checking for PQsetSingleRowMode in -lpq... no >>>> configure: error: libpq library version >= 9.2 is required >> >> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >> back-rev, and you're working in a macOS release that's itself several >> years out of date. You'll need to install a newer libpq to satisfy this >> ODBC version, evidently. > > Is there a way to see what version of PostgreSQL is installed on > the system? > Because then it would be easy to find out what version of ODBC > driver I should have to connect. > Or maybe I already have the driver, since I have iODBC installed? > > Just checked - driver is not there. pg_config --version. You just need to look for its binary in your system. For homebrew, which I actively use, that would be under /usr/local/. -- Michael
On 12/01/2016 08:47 PM, Igor Korot wrote: > Hi, Tom, > > On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> Igor Korot <ikorot01@gmail.com> writes: >>> This is what I get trying to compile latest source: >> >>>> checking for PQsetSingleRowMode in -lpq... no >>>> configure: error: libpq library version >= 9.2 is required >> >> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >> back-rev, and you're working in a macOS release that's itself several >> years out of date. You'll need to install a newer libpq to satisfy this >> ODBC version, evidently. > > Is there a way to see what version of PostgreSQL is installed on > the system? > Because then it would be easy to find out what version of ODBC > driver I should have to connect. > Or maybe I already have the driver, since I have iODBC installed? A question I should have asked earlier, is it a requirement that ODBC be used for the connection? In other words is this a third party app needing ODBC or something you wrote that you want to connect via ODBC? > > Just checked - driver is not there. > > Thank you. > >> >> There isn't any separate distribution of libpq alone; you need to >> build and install all of Postgres into, say, /usr/local. That's >> not hard, but if you don't enjoy rolling it all yourself, you might >> want to consider installing from MacPorts or Homebrew. >> >> regards, tom lane > > -- Adrian Klaver adrian.klaver@aklaver.com
On Fri, Dec 2, 2016 at 3:29 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: > On 12/01/2016 08:47 PM, Igor Korot wrote: >> >> Hi, Tom, >> >> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> >>> Igor Korot <ikorot01@gmail.com> writes: >>>> >>>> This is what I get trying to compile latest source: >>> >>> >>>>> checking for PQsetSingleRowMode in -lpq... no >>>>> configure: error: libpq library version >= 9.2 is required >>> >>> >>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >>> back-rev, and you're working in a macOS release that's itself several >>> years out of date. You'll need to install a newer libpq to satisfy this >>> ODBC version, evidently. >> >> >> Is there a way to see what version of PostgreSQL is installed on >> the system? >> Because then it would be easy to find out what version of ODBC >> driver I should have to connect. >> Or maybe I already have the driver, since I have iODBC installed? > > > A question I should have asked earlier, is it a requirement that ODBC be > used for the connection? > > In other words is this a third party app needing ODBC or something you wrote > that you want to connect via ODBC? You should be careful if you consider ODBC, its usage makes sense if you want to have an application layer able to work with multiple database systems as its routines are the same for all ODBC drivers, say Oracle, MSSQL, Postgres and DB2. So using it can simplify your life, and also complicate it as each database system has its properties, SQL grammar, session tweaks, etc. -- Michael
Hi, Michael, On Fri, Dec 2, 2016 at 1:15 AM, Michael Paquier <michael.paquier@gmail.com> wrote: > On Fri, Dec 2, 2016 at 1:47 PM, Igor Korot <ikorot01@gmail.com> wrote: >> Hi, Tom, >> >> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> Igor Korot <ikorot01@gmail.com> writes: >>>> This is what I get trying to compile latest source: >>> >>>>> checking for PQsetSingleRowMode in -lpq... no >>>>> configure: error: libpq library version >= 9.2 is required >>> >>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >>> back-rev, and you're working in a macOS release that's itself several >>> years out of date. You'll need to install a newer libpq to satisfy this >>> ODBC version, evidently. >> >> Is there a way to see what version of PostgreSQL is installed on >> the system? >> Because then it would be easy to find out what version of ODBC >> driver I should have to connect. >> Or maybe I already have the driver, since I have iODBC installed? >> >> Just checked - driver is not there. > > pg_config --version. You just need to look for its binary in your > system. For homebrew, which I actively use, that would be under > /usr/local/. [code] Igors-MacBook-Air:buildMac igorkorot$ pg_config --version PostgreSQL 9.1.9 [/code] 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. Thank you. > -- > Michael
Hi, Adrian, On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: > On 12/01/2016 08:47 PM, Igor Korot wrote: >> >> Hi, Tom, >> >> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> >>> Igor Korot <ikorot01@gmail.com> writes: >>>> >>>> This is what I get trying to compile latest source: >>> >>> >>>>> checking for PQsetSingleRowMode in -lpq... no >>>>> configure: error: libpq library version >= 9.2 is required >>> >>> >>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >>> back-rev, and you're working in a macOS release that's itself several >>> years out of date. You'll need to install a newer libpq to satisfy this >>> ODBC version, evidently. >> >> >> Is there a way to see what version of PostgreSQL is installed on >> the system? >> Because then it would be easy to find out what version of ODBC >> driver I should have to connect. >> Or maybe I already have the driver, since I have iODBC installed? > > > A question I should have asked earlier, is it a requirement that ODBC be > used for the connection? > > In other words is this a third party app needing ODBC or something you wrote > that you want to connect via ODBC? This is a software I'm writing and for testing purposes I need to use it. It is cross-platform cross-database one. One of the use-cases is to connect to the PostgreSQL thru the ODBC. BTW, is there another way (a "native" way to talk to PostgreSQL server? Thank you. > > >> >> Just checked - driver is not there. >> >> Thank you. >> >>> >>> There isn't any separate distribution of libpq alone; you need to >>> build and install all of Postgres into, say, /usr/local. That's >>> not hard, but if you don't enjoy rolling it all yourself, you might >>> want to consider installing from MacPorts or Homebrew. >>> >>> regards, tom lane >> >> >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
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. -- Michael
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. Thank you. > -- > Michael
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. So looking here: https://www.postgresql.org/support/versioning/ you see Postgres 9.2 was released September 2012. The looking here: https://www.postgresql.org/ftp/odbc/versions/src/ you see that you probably want an psqlodbc version that is psqlodbc-09.01.0100 or older. > > Thank you. > >> -- >> Michael > > -- Adrian Klaver adrian.klaver@aklaver.com
On 12/02/2016 07:38 PM, Igor Korot wrote: > Hi, Adrian, > > On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: >> On 12/01/2016 08:47 PM, Igor Korot wrote: >>> >>> Hi, Tom, >>> >>> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>>> >>>> Igor Korot <ikorot01@gmail.com> writes: >>>>> >>>>> This is what I get trying to compile latest source: >>>> >>>> >>>>>> checking for PQsetSingleRowMode in -lpq... no >>>>>> configure: error: libpq library version >= 9.2 is required >>>> >>>> >>>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >>>> back-rev, and you're working in a macOS release that's itself several >>>> years out of date. You'll need to install a newer libpq to satisfy this >>>> ODBC version, evidently. >>> >>> >>> Is there a way to see what version of PostgreSQL is installed on >>> the system? >>> Because then it would be easy to find out what version of ODBC >>> driver I should have to connect. >>> Or maybe I already have the driver, since I have iODBC installed? >> >> >> A question I should have asked earlier, is it a requirement that ODBC be >> used for the connection? >> >> In other words is this a third party app needing ODBC or something you wrote >> that you want to connect via ODBC? > > This is a software I'm writing and for testing purposes I need to use it. > It is cross-platform cross-database one. > > One of the use-cases is to connect to the PostgreSQL thru the ODBC. > > BTW, is there another way (a "native" way to talk to PostgreSQL server? Using libpq: https://www.postgresql.org/docs/9.5/static/libpq.html There is also JDBC: https://jdbc.postgresql.org/ Then there are all the other language bindings eg Python, PERL, etc. It really depends on what you are calling native. > > Thank you. > >> >> >>> >>> Just checked - driver is not there. >>> >>> Thank you. >>> >>>> >>>> There isn't any separate distribution of libpq alone; you need to >>>> build and install all of Postgres into, say, /usr/local. That's >>>> not hard, but if you don't enjoy rolling it all yourself, you might >>>> want to consider installing from MacPorts or Homebrew. >>>> >>>> regards, tom lane >>> >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
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. > > Thank you. > >> -- >> Michael > > -- Adrian Klaver adrian.klaver@aklaver.com
Adrian, On Sat, Dec 3, 2016 at 9:25 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: > On 12/02/2016 07:38 PM, Igor Korot wrote: >> >> Hi, Adrian, >> >> On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian.klaver@aklaver.com> >> wrote: >>> >>> On 12/01/2016 08:47 PM, Igor Korot wrote: >>>> >>>> >>>> Hi, Tom, >>>> >>>> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>>>> >>>>> >>>>> Igor Korot <ikorot01@gmail.com> writes: >>>>>> >>>>>> >>>>>> This is what I get trying to compile latest source: >>>>> >>>>> >>>>> >>>>>>> checking for PQsetSingleRowMode in -lpq... no >>>>>>> configure: error: libpq library version >= 9.2 is required >>>>> >>>>> >>>>> >>>>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit >>>>> back-rev, and you're working in a macOS release that's itself several >>>>> years out of date. You'll need to install a newer libpq to satisfy >>>>> this >>>>> ODBC version, evidently. >>>> >>>> >>>> >>>> Is there a way to see what version of PostgreSQL is installed on >>>> the system? >>>> Because then it would be easy to find out what version of ODBC >>>> driver I should have to connect. >>>> Or maybe I already have the driver, since I have iODBC installed? >>> >>> >>> >>> A question I should have asked earlier, is it a requirement that ODBC be >>> used for the connection? >>> >>> In other words is this a third party app needing ODBC or something you >>> wrote >>> that you want to connect via ODBC? >> >> >> This is a software I'm writing and for testing purposes I need to use it. >> It is cross-platform cross-database one. >> >> One of the use-cases is to connect to the PostgreSQL thru the ODBC. >> >> BTW, is there another way (a "native" way to talk to PostgreSQL server? > > > Using libpq: > > https://www.postgresql.org/docs/9.5/static/libpq.html > > There is also JDBC: > > https://jdbc.postgresql.org/ > > Then there are all the other language bindings eg Python, PERL, etc. It > really depends on what you are calling native. Using libpg, as it uses PostgreSQL calls, and I presume, is written in C/C++. Versus ODBC/JDBC which ingtroducec another layer in between client app and DB server. Thank you. > > >> >> Thank you. >> >>> >>> >>>> >>>> Just checked - driver is not there. >>>> >>>> Thank you. >>>> >>>>> >>>>> There isn't any separate distribution of libpq alone; you need to >>>>> build and install all of Postgres into, say, /usr/local. That's >>>>> not hard, but if you don't enjoy rolling it all yourself, you might >>>>> want to consider installing from MacPorts or Homebrew. >>>>> >>>>> regards, tom lane >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com >> >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
Adrian, On Sat, Dec 3, 2016 at 9:20 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. > > > So looking here: > > https://www.postgresql.org/support/versioning/ > > you see Postgres 9.2 was released September 2012. > > The looking here: > > https://www.postgresql.org/ftp/odbc/versions/src/ > > you see that you probably want an psqlodbc version that is > psqlodbc-09.01.0100 or older. I will try that version and if not go older. Thx. > > >> >> Thank you. >> >>> -- >>> Michael >> >> >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
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. OK, got it. Thx. > > >> >> Thank you. >> >>> -- >>> Michael >> >> >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
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? Thank you. > > OK, got it. > Thx. > >> >> >>> >>> Thank you. >>> >>>> -- >>>> Michael >>> >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com
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 > > Thank you. > >> >> OK, got it. >> Thx. >> >>> >>> >>>> >>>> Thank you. >>>> >>>>> -- >>>>> Michael >>>> >>>> >>>> >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
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
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
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
On 12/03/2016 11:00 AM, Igor Korot wrote: > Adrian, > >> >> 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? >> I have not used iODBC. A search found this: http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ Technical What's an odbc.ini and what do I put in it? ... -- Adrian Klaver adrian.klaver@aklaver.com
On 12/03/2016 11:00 AM, Igor Korot wrote: > Adrian, > > Thank you. > > BTW, is there a setup library generated? Maybe that the reason the driver is > not in the list? > >> To add: http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/ODBCOnUnix -- Adrian Klaver adrian.klaver@aklaver.com