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 1
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 ow
ner.objectname or use sp_help to check whether the object exists (sp_help ma
y produce lots of output).
]
OLE DB error trace [OLE/DB Provider 'Sybase.ASEOLEDBProvider' IColumnsIn
fo::GetColumnsInfo returned 0x80004005: ].
Monday, March 12, 2012
server-New tables missing
Labels:
ase,
database,
disconnect,
hthgt-original,
linked,
message-gti,
microsoft,
missing,
mysql,
oracle,
re-fresh,
reconnectthe,
server,
server-new,
sounds,
sql,
sybase,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment