Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting data from SQL Management Studio

Status
Not open for further replies.

look444like

Technical User
Jun 18, 2009
1
US
select * from UIP_CONFIG.config_epro.dbo.Service_Group

I am encountering a problem of accessing the Sybase table from Sql Server 2005. There are in all 12 tables and only three out of them are not accessible.When I tried to access them from Sybase I can access them there.I get this error for two tables.Msg 7313, Level 16, State 1, Line 1An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "UIP_CONFIG".There is a table that cannot be acessed either place. The error message is Msg 7314, Level 16, State 1, Line 2The OLE DB provider "MSDASQL" for linked server "UIP_LOOKUP" does not contain the table "lookup.dbo.Service_Type". The table either does not exist or the current user does not have permissions on that table.Thanks in Advance
 
does the security context that you are using to connect to the linked server have the necessary privileges to select from the tables which you are trying to see?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top