Re: [ODBC] ODBC constructs

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 5/21/2013 3:49 PM, Dev Kumkar wrote:

On Tue, May 21, 2013 at 3:17 PM, John R Pierce <pierce@xxxxxxxxxxxx> 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