Prev: Shrink on Log Shipping process
Next: Log Shipping shrink the secondary server.
From: Cesar on 28 Dec 2009 20:39
I have the same problem.
I resolved with this:

Here is the text of the proc in case you ever need to do the same, create it in the master database:

create procedure sp_tables_info_rowset_64

@table_name sysname,

@table_schema sysname = null,

@table_type nvarchar(255) = null

as

declare @Result int set @Result = 0

exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
go




James wrote:

I am getting the exact results with an upgrade of SQL 2005 to 2008 querying a
27-Aug-08

I am getting the exact results with an upgrade of SQL 2005 to 2008 querying a
SQL 2000 SP4 linked server.

I need this to work. Microsoft?

"Bill Wang" wrote:

Previous Posts In This Thread:

On Tuesday, August 12, 2008 1:55 PM
BillWan wrote:

SQL 2008 Linked serverto SQL 2000
Hi All,
I installed SQL 2008 x64 on Windows 2003 R2 X64 SP2. Also I installed 64
Bit Msdasql.dll. This server was installed SQL 2005 with SP2, and I removed
SQL 2005 before installing SQL 2008.
When I created a linked server from SQL 2008 to SQL 2000 sp4 I met some
strange things.
First, If I choose the linked server type as SQL Server to create the
linked server to SQL 200 SP4, I can't use a full object name to access the
data in linked server. such as: select * from
mylinkedserver.mydbname.dbo.mytable. This query reported errors as :
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" returned
message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" 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 "mylinkedserver". The provider supports the
interface, but returns a failure code when it is used.

But if I use openquery, everything is ok. for example:
select * from openquery(mylinkedserver,'select * from mydbname.dbo.mytable')

Then if I use OLEDB provide to create the same linked server using following
connection string:
Provider=sqloledb;Data Source=mylinkedserver;Initial
Catalog=mydbname;Integrated Security=SSPI;

I can't get any data return by

select * from openquery(mylinkedserver,'select * from mydbname.dbo.mytable')

or

select * from mylinkedserver.mydbname.dbo.mytable

And there is no any error for above queries.

Thanks for any help!


Bill

On Wednesday, August 27, 2008 10:09 PM
James wrote:

I am getting the exact results with an upgrade of SQL 2005 to 2008 querying a
I am getting the exact results with an upgrade of SQL 2005 to 2008 querying a
SQL 2000 SP4 linked server.

I need this to work. Microsoft?

"Bill Wang" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Toward a Generic Data Access WebService
http://www.eggheadcafe.com/tutorials/aspnet/2be079b9-cbe9-46b1-862b-99b484d8cda8/toward-a-generic-data-acc.aspx
 | 
Pages: 1
Prev: Shrink on Log Shipping process
Next: Log Shipping shrink the secondary server.