Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OPENROWSET in 2008 Expand / Collapse
Author
Message
Posted Friday, October 30, 2009 12:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
SELECT a.* FROM OPENROWSET('SQLOLEDB',
'DRIVER={SQL Server};SERVER=IPaddress;UID=xxx;PWD=xxx,
RAIS.dbo.LMS_Discipline) AS a

the above query working fine as between two server in version of sql server 2000, source sql server 2000 32bit and sp4

destination server sql server 2008, 64 bit.
The above query try to execute in sql 2008 machine does not working, i could try to change SQLNCLI insted of SQLOLEDB, but it was not hope.

Error Msg:
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used.
------------------


Thanks for help.
Post #811371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse