I have a linked server to Sybase ASE 12.5 that has been working great. However, now when new tables are created in the Sybase db they can't be found using the linked server connection. The login the linked server is using has all permissions granted on the new tables too. Any ideas?Sounds like a re-fresh problem, disconnect and reconnect
the server.
hth
>--Original Message--
>I have a linked server to Sybase ASE 12.5 that has been
working great. However, now when new tables are created
in the Sybase db they can't be found using the linked
server connection. The login the linked server is using
has all permissions granted on the new tables too. Any
ideas?
>.
>|||I've tried that and I've even created a new linked server. They still don't show up. I tried executing a query using Query analyzer and here's the SQL and error message I get
select i_con_contract from openquery([32tlsql2-dreamdb],
'Select i_con_contract From dbo.temp_client_3' )
Server: Msg 7399, Level 16, State 1, Line
OLE DB provider 'Sybase.ASEOLEDBProvider' reported an error.
[OLE/DB provider returned message: [Native Error code: 208
[DataDirect ADO Sybase Provider] dbo.temp_client_3 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)
OLE DB error trace [OLE/DB Provider 'Sybase.ASEOLEDBProvider' IColumnsInfo::GetColumnsInfo returned 0x80004005: ].
No comments:
Post a Comment