Re: [ODBC] ODBC constructs

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

On Tue, May 21, 2013 at 8:40 PM, Dann Corbit <DCorbit@xxxxxxxxx> wrote:

>>

I guess that if you did a successful make install of unixODBC-2.3.0 it will work as your ODBC driver manager.

On the other hand, it is easier and more trouble free to use the standardized package installer for your distribution.

<< 

Yes unixODBC-2.3.0 successfully installed.

On Tue, May 21, 2013 at 9:02 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:

I have no idea what you're saying here.   what 1st package?  you should apply all pending updates to your operating system as a matter of good practice.    if this is a production system, you should of course, test the updates on a staging server before updating production.

Yes, actually package update started but need to get this done on stage server first for existing packages. I meant if unixODBC-libs is not present on this system then update for it will not be patched.

 

again,  simply...

    yum install unixODBC-libs

that should install the ODBC runtime libraries that the postgres driver requires.  if it doesn't then you don't have access to the RHEL repositories, which suggests you're either not a subscriber, or you haven't properly registered this system via your Red Hat Network account.   If this system doesn't have a paid Red Hat Enterprise Linux support contract, then you really shouldn't BE running Red Hat Enterprise Linux as you can't install anything, can't get security updates, or anything.  CentOS 5 or 6 are compatible rebuilds with free public repositories.

Need to check this tomorrow regarding registration.

BTW where does the 'postgresql91-odbc.x86_64' looking for libodbc.so.1 and libodbcinst.so.1 files.
unixODBC-2.3.0 was successfully installed and both these libraries are under /usr/local/lib/.
# ldd libodbc.so.1
        libdl.so.2 => /lib64/libdl.so.2 (0x00002b3fb5661000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b3fb5865000)
        libc.so.6 => /lib64/libc.so.6 (0x00002b3fb5a80000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003164800000)

Also tried to export PATH and LD_LIBRARY_PATH and then ran 'yum install postgresql91-odbc' but still facing same errors:
     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)

Any particular location or is it like unixODBC-2.3.0 installation is not enough to bless 'postgresql91-odbc.x86_64' package installation.

Regards...