Re: [ODBC] ODBC constructs

On Tue, May 21, 2013 at 8:40 PM, Dann Corbit <DCorbit(at)connx(dot)com> 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(at)hogranch(dot)com> 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...