sqlclr - SQL Server custom CLR fails with error "Could not load file or assembly or one of its dependencies. The system cannot find the file specified." -

-

i have created sql clr references windows dll, windowsbase. part clr works fine if windowsbase gets updated in gac error "assembly in host store has different signature assembly in gac.".

to address built clr reference version of windowsbase not in gac. when run clr error "could not load file or assembly 'windowsbase, version=4.0.0.0, ...' or 1 of dependencies. system cannot find file specified."

i set fuslogvw see what's going on , following output 

the system cannot find file specified.  assembly manager loaded from:  c:\windows\microsoft.net\framework64\v4.0.30319\clr.dll running under executable  c:\program files\microsoft sql server\mssql11.mssqlserver\mssql\binn\sqlservr.exe --- detailed error log follows.   === pre-bind state information ===     log: displayname = windowsbase, version=4.0.0.0     log: appbase = file:///c:/program files/microsoft sql server/mssql11.mssqlserver/mssql/binn/     log: initial privatepath = null     log: dynamic base = null     log: cache base = null     log: appname = sqlservr.exe     calling assembly : (unknown).     ===     log: bind starts in default load context.     log: no application configuration file found.     log: using host configuration file:      log: using machine configuration file c:\windows\microsoft.net\framework64\v4.0.30319\config\machine.config.     log: post-policy reference: windowsbase, version=4.0.0.0     log: same bind seen before, , failed hr = 0x80070002.     err: unrecoverable error occurred during pre-download check (hr = 0x80070002).

it appear assembly loader using machine.config file determine should assembly. based on assumption updated machine.config 

<runtime>     <assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1">         <dependentassembly>              <assemblyidentity name="windowsbase"... />               <codbase version="4.0.0.0"                    href="./additionalassemblies/windowsbase.dll"/>         </dependentassembly>     </assemblybinding> </runtime>

i have tried relative path (relative sqlservr.exe) , absolute path continue same error mentioned above. suggestions on how set sql clr refereneces copy of windowsbase outside gac without getting above errors appreciated.

~bugz~

what attempting not supported sql server's clr host. clr within sql server highly restricted prevent destabilizing sql server since works differently apps running on os. so, there limited set of dlls supported (i.e. verified work , guaranteed stay working across updates .net). windowsbase not 1 of them need load manually unsafe sql server. leaves either problem ran of version in main gac changing (dlls common between gac , sql server's clr host must same version), or worse, if dll becomes "mixed" (both unmanaged c++ , managed code) , no longer "pure". in case new version not load , old version gets "wrong version" error have work do.

for more detailed information, please see following articles / documentation:

that set of links taken "additional reading" section of article wrote: stairway sqlclr level 5: development (using .net within sql server) (free registration required)


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile:
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo
Read more