Thread: BUG #6557: post gre sql odbc connection issue

BUG #6557: post gre sql odbc connection issue

From
vikas.arora@rbs.com
Date:
The following bug has been logged on the website:

Bug reference:      6557
Logged by:          vikas a
Email address:      vikas.arora@rbs.com
PostgreSQL version: 9.0.1
Operating system:   Linux and Windows
Description:=20=20=20=20=20=20=20=20

Hi

I am using postgre sql odbc connection version 9.01 to connect jboss teiid
which is setup up on linux host from my windows machine using excel, obiee
11g client, business objects, etc.

The issue which I am facing is that I am able to connect to the data source
(i.e. teiid) but unable to see the fields under the tables. When I use
squirrel tool to connect to teiid using jdbc connection I am able to see the
columns and data successfully.

Can you please tell me what could be the problem, what setting need to be
done on datasource to enable this level of access?

Thanks.
Vikas

Re: BUG #6557: post gre sql odbc connection issue

From
Robert Haas
Date:
On Mon, Mar 26, 2012 at 1:41 AM,  <vikas.arora@rbs.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =A0 =A0 =A06557
> Logged by: =A0 =A0 =A0 =A0 =A0vikas a
> Email address: =A0 =A0 =A0vikas.arora@rbs.com
> PostgreSQL version: 9.0.1
> Operating system: =A0 Linux and Windows
> Description:
>
> Hi
>
> I am using postgre sql odbc connection version 9.01 to connect jboss teiid
> which is setup up on linux host from my windows machine using excel, obiee
> 11g client, business objects, etc.
>
> The issue which I am facing is that I am able to connect to the data sour=
ce
> (i.e. teiid) but unable to see the fields under the tables. When I use
> squirrel tool to connect to teiid using jdbc connection I am able to see =
the
> columns and data successfully.
>
> Can you please tell me what could be the problem, what setting need to be
> done on datasource to enable this level of access?

I doubt this is a bug.  You might want to try posting your question to
the pgsql-odbc mailing list.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company