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

SMO compatibility error Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 5:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 4, 2012 5:39 PM
Points: 1, Visits: 4
Is anyone aware of any forward compatibility bug in the SMO library?
We are having an issue with a .NET client using SMO to check for create database permission.
It seems to have trouble reading the 2008 R2 library when communicating with SQL 2012.
Post #1354262
Posted Monday, January 5, 2015 8:27 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 21, 2015 9:47 AM
Points: 98, Visits: 224
When using SMO for SQL Server you need to remember that going backwards is supported but going forward will not always work. In your case this is especially true. Get the updated SMO libraries for the version of SQL Server you are running and things will work correctly.



Ben Miller
Microsoft Certified Master: SQL Server, SQL MVP
@DBAduck - http://dbaduck.com
Post #1648326
Posted Friday, April 24, 2015 2:16 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:23 AM
Points: 3,160, Visits: 857
Backwards always supported ? Not sure ...
Because the library is changing and you can have problems with classes changing from dll .
It is why I am always advicing to import the SMO dll in the application : with a fatter code but your application is working against every version of SQL Server. I have had at least answered three times on the SMO Forum ( MSDN ) , supported every time by some MSFT moderators.
You may have also problems with versions in R2 ( like SQL Server 2008 R2 ) which had the bad habit to replace the existing dll as they were installed in the same folder with the same name.
Post #1680094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse