DBMS is ASA 9.0.2.3951 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?

Update:

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.

asked 16 Aug '13, 01:14

Chudinov's gravatar image

Chudinov
31225
accept rate: 0%

edited 16 Aug '13, 06:48

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124

It would be helpfull if you specify more details: which connection parameters and which driver are you using to connect with the Oracle db?

(16 Aug '13, 03:05) Reimer Pods

If you need to add more details, please edit your question rather than add an answer. Answers should only be for actual answers to the question. I've done this for you here.

(16 Aug '13, 06:49) Graeme Perrow

Sybase Central is probably calling dbo.sp_remote_columns() which is failing for some strange reason. Try issuing the CREATE EXISTING TABLE statement directly in DBISQL and see if that works or gives you more details as to why the column information is not coming back.

permanent link

answered 16 Aug '13, 12:23

Karim%20Khamis's gravatar image

Karim Khamis
5.7k53870
accept rate: 40%

I tried CREATE EXISTING TABLE statement in DBISQL with column defition and without. The result is the same. No more information just the error message.

(19 Aug '13, 00:47) Chudinov
Replies hidden

Does the following work when issued via DBISQL (assumption: SRV_ORA is the server name as specified in the CREATE SERVER statement):

FORWARD TO SRV_ORA;
SELECT * FROM <your native Oracle table schema and name>;
FORWARD TO;

(That's just a test whether the ASA user can access the remote table when the select is sent as a native command to the remote server.)

(19 Aug '13, 07:28) Volker Barth

Yes, it works.

(19 Aug '13, 23:03) Chudinov
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×70

question asked: 16 Aug '13, 01:14

question was seen: 2,420 times

last updated: 19 Aug '13, 23:03