From: | "Govender, Maya" <maya(dot)govender(at)ebucks(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Psql DBC -08.02.0400 problem, only public schema can be viewed. |
Date: | 2007-08-15 10:50:41 |
Message-ID: | 2717D3241ABADE498BA28828528674B10A69FB24@fnbsdnmx01.fnb.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
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.
Kindly advise as to a possible workaround or fix for this issue, please
see Comments below from SAS support regarding this issue,
"Development confirmed that the ODBC driver is the reason for the
behavior.
SAS query the odbc driver regarding Schema usage and the PostgreSQL
driver comes back basically saying "no schema usage". Therefore tables
are not prefix'ed with the schema.
ODBC: ENTER SQLGetInfo
0x000000000033e530
91 <SQL_SCHEMA_USAGE>
0x0000000078024528
4
0x000000007307c0fe
ODBC: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
0x000000000033e530
91 <SQL_SCHEMA_USAGE>
0x000000007307bf4c (0) <> <---- This is the
information returned from the PostgreSQL driver - no schema usage
4
0x000000007307c0fe (4)
This is what the driver should return (exmple with oracle's odbc
driver):
ODBC: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
0x049a1348
91 <SQL_SCHEMA_USAGE>
0x0495f028 (31) <SQL_SU_DML_STATEMENTS |
SQL_SU_PROCEDURE_INVOCATION | SQL_SU_TABLE_DEFINITION |
SQL_SU_INDEX_DEFINITION
| SQL_SU_PRIVILEGE_DEFINITION>
4
0x0495f2be (4)
I suggest that they contact the ODBC driver vendor with the issue. Maybe
there is an option to turn on the schema usage within the driver
configuration."
Kind Regards
Maya Govender
Tel: 011 263 5009
Fax: 011 263 5131
Cell: 082 550 9180
email: maya(dot)govender(at)ebucks(dot)com
This email is subject to a disclaimer, which is available at: https://www.ebucks.com/email/disclaimer.html
If you are unable to access the Disclaimer, send a blank e-mail to disclaimer(at)ebucks(dot)com and we will send you a copy of the Disclaimer.
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2007-08-16 01:24:26 | Re: Psql DBC -08.02.0400 problem, only public schema can be viewed. |
Previous Message | lothar.behrens@lollisoft.de | 2007-08-10 16:18:51 | Re: UPDATE with data at exec and CURRENT OF question |