newbie tries to get oracle db to select from postgresql

Поиск
Список
Период
Сортировка
От Ray Stell
Тема newbie tries to get oracle db to select from postgresql
Дата
Msg-id 56C5CDAA.5000808@vt.edu
обсуждение исходный текст
Ответы Re: newbie tries to get oracle db to select from postgresql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-odbc
Forgive me if this is a misplaced post.

I've been requested to get an Oracle 11g db to be able to select from a
postgresql 9.4 db and I've never gone here before.  I was reading from here:
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
and it says to install odbc rpm on the oracle server:  # yum install
postgresql91-odbc  on the oracle server.

The one available is older:
 > yum info postgresql-odbc.x86_64
Loaded plugins: priorities, ulninfo
Available Packages
Name        : postgresql-odbc
Arch        : x86_64
Version     : 08.04.0200
Release     : 1.el6
Size        : 267 k
Repo        : ol6_latest
Summary     : PostgreSQL ODBC driver
URL         : http://psqlodbc.projects.postgresql.org/
License     : LGPLv2+
Description : This package includes the driver needed for applications
to access a
             : PostgreSQL system via ODBC (Open Database Connectivity).

Is this ok to use with postgresql 9x?  If not do I need to install
postgresql server components in order to build psqlodbc-09.05.0100?

Is there a better, detailed howto on this topic?


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Следующее
От: "John Van De Giessen"
Дата:
Сообщение: Re: Issue with Money field using ODBC to Access database