Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UexrA-0003kJ-SI for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 01:28:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Uexr9-0002TB-Tv for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 01:28:43 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Uexqv-0002He-TA for pgsql-general@postgresql.org; Wed, 22 May 2013 01:28:30 +0000 Received: from hogranch.com ([75.101.82.47]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uexqp-00016q-C0 for pgsql-general@postgresql.org; Wed, 22 May 2013 01:28:29 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id r4M1SFl30750 for ; Tue, 21 May 2013 18:28:15 -0700 Message-ID: <519C1F2F.8040708@hogranch.com> Date: Tue, 21 May 2013 18:28:15 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: "pgsql-general@postgresql.org" Subject: Re: [ODBC] ODBC constructs References: <519B14E7.3010806@vmware.com> <519BC7F5.1010703@hogranch.com> <87F42982BF2B434F831FCEF4C45FC33E64E8083A@EXCHANGE.corporate.connx.com> <519BF280.8060008@hogranch.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------080404070503070007010202" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------080404070503070007010202 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 5/21/2013 3:49 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 3:17 PM, John R Pierce > wrote: > > what specific non-Windows operating system distribution are you > using? ODBC stuff is packaged for most of them. for instance, > the yum.postgresql.org repository has > it packaged as postgresql92-odbc, available for a variety of > redhat/fedora/centos style systems, I'm sure the debian/ubuntu apt > repositories have similar. > > > Currently looking for RHEL 5. Thanks! yes looked into my machine and > "yum list postgres*" listed "postgresql91-odbc.x86_64" > But when trying to install, then found the base ODBC library itself > are missing and those needs to be configured first on test machine. > > Error: Missing Dependency: libodbc.so.1()(64bit) is needed by package > postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) > Error: Missing Dependency: libodbcinst.so.1()(64bit) is needed by > package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) that should have come from the base repository... # yum provides libodbc.so.1 Loaded plugins: fastestmirror, priorities Loading mirror speeds from cached hostfile * base: centos.mirrors.hoobly.com * extras: centos.mirror.freedomvoice.com * updates: centos-distro.cavecreek.net unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by programs that use unixODBC Repo : base Matched from: Other : libodbc.so.1 unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by programs that use unixODBC Repo : installed Matched from: Other : Provides-match: libodbc.so.1 (on a 32bit EL5 system) -- john r pierce 37N 122W somewhere on the middle of the left coast --------------080404070503070007010202 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 5/21/2013 3:49 PM, Dev Kumkar wrote:
On Tue, May 21, 2013 at 3:17 PM, John R Pierce <pierce@hogranch.com> wrote:
what specific non-Windows operating system distribution are you using?  ODBC stuff is packaged for most of them.  for instance, the yum.postgresql.org repository has it packaged as postgresql92-odbc, available for a variety of redhat/fedora/centos style systems, I'm sure the debian/ubuntu apt repositories have similar.

Currently looking for RHEL 5. Thanks! yes looked into my machine and "yum list postgres*" listed "postgresql91-odbc.x86_64"
But when trying to install, then found the base ODBC library itself are missing and those needs to be configured first on test machine.

Error: Missing Dependency: libodbc.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91)
Error: Missing Dependency: libodbcinst.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91)

that should have come from the base repository...

# yum provides libodbc.so.1
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * base: centos.mirrors.hoobly.com
 * extras: centos.mirror.freedomvoice.com
 * updates: centos-distro.cavecreek.net
unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by programs that use unixODBC
Repo        : base
Matched from:
Other       : libodbc.so.1



unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by programs that use unixODBC
Repo        : installed
Matched from:
Other       : Provides-match: libodbc.so.1

(on a 32bit EL5 system)


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast
--------------080404070503070007010202--