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

<<  June 2017  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789

View posts in large calendar

Blogroll

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 2017

Subscribe