look444like
Technical User
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
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