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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2007-08-16 08:16:34 | Re: UPDATE with data at exec and CURRENT OF question |
Previous Message | Govender, Maya | 2007-08-15 10:50:41 | Psql DBC -08.02.0400 problem, only public schema can be viewed. |