Re: [ODBC] ODBC constructs
| От | Dev Kumkar |
|---|---|
| Тема | Re: [ODBC] ODBC constructs |
| Дата | |
| Msg-id | CALSLE1MSJnngyi1CiHZ-ySy1bU3mkuwURGww3mMN6kcLR3Vc4w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [ODBC] ODBC constructs (John R Pierce <pierce@hogranch.com>) |
| Ответы |
Re: [ODBC] ODBC constructs
(John R Pierce <pierce@hogranch.com>)
|
| Список | pgsql-general |
On Tue, May 21, 2013 at 8:40 PM, Dann Corbit <DCorbit@connx.com> wrote:
Yes unixODBC-2.3.0 successfully installed.>>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.
<<
On Tue, May 21, 2013 at 9:02 PM, John R Pierce <pierce@hogranch.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)
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...
В списке pgsql-general по дате отправления: