DBMS is ASA 220.127.116.1151 on SuSe Linux 10.1 32-bit host. I'm using a master in Sybase Central for create proxy table of Oracle 10g database table. I've got an error with SQLCODE -667 "Could not access column information for the table '%1'". Documentation says that prabable couse may by "Column information for the table could not be accessed. Check privileges for the table". I can't understand what does it mean. I have SELECT privilege on this table(view) in Oracle database. What i must to do to avoid this error?
I'm using an Oracle WP Driver.
There is a part from odbc.ini
[ODBC Data Sources] OraSRC=iAnywhere Solutions 9 - Oracle Wire Protocol Driver [OraSRC] Driver=/opt/sybase/SYBSsa9/drivers/lib/wqora19.so Description=iAnywhere Solutions 9 - Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescriptionLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=1 DefaultLongDataBuffLen=1024 DescribeAtPrepare=1 EnableDescribeParam=1 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=1 EnableTimestampWithTimeZone=0 HostName= here the fqdn of the oracle db host LocalTimeZoneOffset= LockTimeOut=5 LogonID= here the username of oracle user Password= user password PortNumber=1521 ProcedureRetResults=1 SID=B UseCurrentSchema=0
I put the OraSRC to connection parameters when creating the remote server in Sybase Central. Remote server was sucessfully created. Then i tried to create a proxy table, peek the db name and choose table name from list and go on.
Sybase Central is probably calling
answered 16 Aug '13, 12:23