> 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.
> 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
> 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?
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Saito||Date: 2007-08-16 08:16:34|
|Subject: Re: UPDATE with data at exec and CURRENT OF question|
|Previous:||From: Govender, Maya||Date: 2007-08-15 10:50:41|
|Subject: Psql DBC -08.02.0400 problem, only public schema can be viewed.|