c# - The type or namespace name 'Nmo' does not exist in the namespace 'Microsoft.SqlServer.Management' -


i tried load project said:

the type or namespace name 'nmo' not exist in namespace 'microsoft.sqlserver.management'

i know smo dll nmo? find that?

update: added smo dll of 2008 version... still giving out error... maybe, should smo dll of sql 2005 version? coz machine got project using sql 2005

quote article titled "microsoft sql server 2005 notification services":

nmo api assemblies , namespaces

to use nmo api, applications must reference assemblies contain needed classes. following 2 assemblies required:

  • microsoft.sqlserver.smo.dll

  • microsoft.sqlserver.connectioninfo.dll

the first assembly, microsoft.sqlserver.smo.dll , contains of classes in smo framework, including nmo classes (there isn't separate nmo assembly). microsoft.sqlserver.connectioninfo.dll contains utility classes used establish database connections. classes both assemblies typically needed in programs use nmo api.

most of classes you'll encounter while working nmo defined in 1 of following 3 namespaces:

  • microsoft.sqlserver.management.nmo

  • microsoft.sqlserver.management.smo

  • microsoft.sqlserver.management.common

the first 1 referred nmo namespace . contains nmo-specific classes. second namespace contains many of smo classes, of needed in nmo programming. third namespace contains common utility classes, such used establish database connections.

edit:

take here, search "microsoft sql server 2005 management" , download appropriate dll. unzipped , appears contain microsoft.sqlserver.smo file. when tried install it, got message instructing me download prerequisite (the sql server native client), , page directed me appears updated version of 2005 dlls, may want use dlls page.

also, side note, if you're connecting 2008 sql server, should able use 2005 dll manage it, newer "2008-specific" features not available using older dll.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more