Skip site navigation (1) Skip section navigation (2)

Re: Psql DBC -08.02.0400 problem, only public schema can be viewed.

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Govender, Maya" <maya(dot)govender(at)ebucks(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Psql DBC -08.02.0400 problem, only public schema can be viewed.
Date: 2007-08-16 01:24:26
Message-ID: 024b01c7dfa4$2f6669e0$c601a8c0@HP22720319231 (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi.

> From: Govender, Maya
> To: pgsql-odbc(at)postgresql(dot)org
> Sent: Wednesday, August 15, 2007 7:50 PM
> Subject: [ODBC] Psql DBC -08.02.0400 problem, only public schema can be viewed.
>
>
> Greetings,
>
> Current environment setup:
>
> OS                   - Solaris 9 Sparc 64 bit
> Application        - SAS 9
> Odbc Driver       - UNIX ODBC 2.2
> Postgres driver   - Psqlodbc-08.02.0400
>
> Problem situation :
>
> Requirements - Access postgres 8.1.3 database from sas ( CRM application ) using unixODBC
> and psqlodbc compiled as 64 bit because sas is installed as 64 bit

Cool:-)

> Current situation - the above is in place , I can access all data/tables in the public
> schema  only, all other schema's cannot be accessed from sas.

Does on the ShowSystemTables of odbc.ini help you?

Regards,
Hiroshi Saito 


In response to

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2007-08-16 08:16:34
Subject: Re: UPDATE with data at exec and CURRENT OF question
Previous:From: Govender, MayaDate: 2007-08-15 10:50:41
Subject: Psql DBC -08.02.0400 problem, only public schema can be viewed.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group