Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Usage of SQL Server libraries
Message
From
17/03/2014 14:15:38
 
 
To
12/03/2014 16:46:11
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01596377
Message ID:
01596685
Views:
33
I have found a way for this to work.

On Windows Server 2003, with SQL Server 2008, even if this is not SQL Server 2012, simply install:

Microsoft SQL Server 2012 Shared Management Objects x86
Microsoft System CLR Types for Microsoft SQL Server System 2012 x86

In your project, establish references to:

Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo
Microsoft.SqlServer.SmoExtended

...version 11.0.0.0.

This will force your application to use SQL Server 2012 32-bit version and will work on SQL Server 2008. So, at least, you won't have to change your project references every time you have to compile for one SQL Server version or another. Then, once Windows Server 2003 and SQL Server 2008 upgraded to SQL Server 2012, you wouldn't have to change anything.

Keep in consideration that making usage of those libraries does require to install the proper SQL Server libraries on the Web server or any other server accessing the SQL Server database server because they do not have any specific SQL Server libraries installed locally for such needs (scripting, Geography field, etc.).

So, with that, on the Web server or any other server accessing the SQL Server database server, you only need to keep:

Microsoft SQL Server 2012 Shared Management Objects x86
Microsoft System CLR Types for Microsoft SQL Server System 2012 x86
Microsoft SQL Server 2012 Shared Management Objects x64
Microsoft System CLR Types for Microsoft SQL Server System 2012 x64

...and can get rid of the 2008 libraries.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform