ASE 15 and linked servers, can't access some tables
Craig
I have an ASE 15 database that I am accessing via linked server from
MS SQL 2008. Both are 32 bit environments. Most of the tables are
fine, but at least one of them I cannot access. I can query it fine
locally on ASE using the same account. So, the following works/does
not work for this table:
Local query on ASE - ok.
SSIS query via OLEDB connection and ADO.Net provider for OlEDB for
Sybase - ok
Linked server query via a connection made with ODBC Adaptive Server
Enterprise driver and Microsoft OLE DB Provider for ODBC Drivers -
error
The OLE DB provider "MSDASQL" for linked server "V6DATAODBC" does not
contain the table "myasedb.dbo.mytable". The table either does not
exist or the current user does not have permissions on that table.
Linked server query via a connection made with ASE OLEDB Provider by
Sybase and the Sybase OLEDB Provider in the linked server connection -
error
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ASEOLEDB" for linked server "V6DATAOLEDB"
reported an error. The provider did not give any information about the
error.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_INDEXES" for OLE DB provider
"ASEOLEDB" for linked server "V6DATAOLEDB". The provider supports the
interface, but returns a failure code when it is used.
So, does anyone have any idea why it works via SSIS and ADO.Net and
locally but won't for linked server? Why does it not work for only
this one table? It only has about 10 rows and about 20 columns!
Craig
