Linked Server Problem

• maxcoder1@gmail.com

  Say Hey Kid

  Points: 684

  More actions

  January 30, 2011 at 6:32 am

  #246027

  Hi All,

  I have a MSSQL2008 and MSSQL2005 in my system.All SP's is up-to-date.

  2008;

  Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

  2005;

  Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

  Now,My question is; I setup to linked to SQL Server 2005 from SQL Server 2008 under the Server Object.But,When I query , I am receiving the following error.

  select * from [192.x.x.x].mydatabase.mytable ;

  Result;

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "SQLNCLI10" for linked server "192.x.x.x" reported an error. The provider did not give any information about the error.

  Msg 7312, Level 16, State 1, Line 1

  Invalid use of schema or catalog for OLE DB provider "SQLNCLI10" for linked server "192.x.x.x". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

  Thanks in advance,

  Cheers,

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  January 30, 2011 at 9:03 am

  #1280187

  You are missing the table’s schema in your query. If you didn’t work with schemas then most chances are that the schema name is dbo (which means that the query should be select * from ServerName.DBName.dbo.TableName)

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• maxcoder1@gmail.com

  Say Hey Kid

  Points: 684

  More actions

  January 30, 2011 at 9:26 am

  #1280192

  Adi Cohn-120898 (1/30/2011)

  ---

  You are missing the table’s schema in your query. If you didn’t work with schemas then most chances are that the schema name is dbo (which means that the query should be select * from ServerName.DBName.dbo.TableName)

  Adi

  First of all, thanks for your feedback.But,I am receiving still same error.

  Cheers,

• maxcoder1@gmail.com

  Say Hey Kid

  Points: 684

  More actions

  February 5, 2011 at 7:37 am

  #1282796

  Any suggestions?

• Umair_aslam786

  Newbie

  Points: 3

  More actions

  February 6, 2011 at 10:29 am

  #1282890

  Please confirm me if i install SQL server 2005 in Windows XP and connect the SQL server through vb/vb.net using SQL adapter so is there any users connection limitation or not? where WINDOWS XP just support 10 users for sharing.....

  Regards,

  UMAIR ASLAM.

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  February 6, 2011 at 7:17 pm

  #1282915

  Can you check if the provider option "Level Zero Only" is checked in Server Objects/Linked Server/Providers/SQLNCLI10

  If it is checked, it could be the cause of the error - if appropriate for your installation, you could try clearing that option - but only after you find out why it is set!

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]