CSLA

by Cliff 27. May 2007

I have been considering using Rockford Lhotka's CSLA framework for an upcoming ASP.NET project.  I was curious if many people are using this framework and what their experiences have been?

http://www.lhotka.net/Default.aspx

SQL Server 2005 64 bit Linked Server Issue

by Cliff 22. May 2007

If you get the below error when trying to create a linked server from a 2005 64 bit instance to a 2000 32 bit instance, you can try the follwoing steps to correct:

  • Execute Instcat.sql on the 2000 instance, which is part of the latest SQL Server 2000 SP 4
  • Change your linked server syntax from servername.db.schema.table to SELECT * FROM OPENQUERY(servername, "...")
One of the causes of this error is a missing stored procedure that the 64 bit instance is looking for.

OLE DB provider "SQLNCLI" for linked server "servername" returned message "Unspecified error".

OLE DB provider "SQLNCLI" for linked server "servername" 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 "SQLNCLI" for linked server "servername". The provider supports the interface, but returns a failure code when it is used.

Cliff Gray's Info

Cliff Gray
Developer/Founder GrayTechnology.com.

E-mail me Send mail

Authors

Calendar

<<  August 2018  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

Download BlogEngine.NET

Download at CodePlex

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2018

Subscribe