Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Usage of SQL Server libraries
Message
De
17/03/2014 14:15:38
 
 
À
12/03/2014 16:46:11
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01596377
Message ID:
01596685
Vues:
34
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform