Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL server 2008 CLR version #4

Open
SQLadmin opened this issue Mar 1, 2016 · 1 comment
Open

SQL server 2008 CLR version #4

SQLadmin opened this issue Mar 1, 2016 · 1 comment

Comments

@SQLadmin
Copy link

SQLadmin commented Mar 1, 2016

Unable to create Assembly in SQL server 2008. it throws the error.
CREATE ASSEMBLY for assembly 'SqlServerSlackAPI' failed because assembly 'SqlServerSlackAPI' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message

So I changed the target framework version in visual studio and builds but it throws some error.

------ Build started: Project: SqlServerSlackAPI, Configuration: Debug Any CPU ------
C:\Program Files (x86)\MSBuild\12.0\bin\Csc.exe /noconfig /nowarn:1701,1702,2008 /nostdlib+ /warn:4 /define:DEBUG;TRACE /errorendlocation /preferreduilang:en-US /highentropyva- /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /debug+ /debug:full /keycontainer:VS_KEY_9EEE88A9BEA24A1E /optimize- /out:obj\Debug\SqlServerSlackAPI.dll /target:library /utf8output Properties\AssemblyInfo.cs Include_T4Include.cs UserDefinedFunctions.cs SlackChatApi.cs SlackChatMessageResult.cs "C:\Users\bhuvanesh\AppData\Local\Temp\3.NETFramework,Version=v3.5.SqlClrAttributes.cs"
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(83,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(89,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(95,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
Done building project "SqlServerSlackAPI.sqlproj" -- FAILED.

@Crucial2K
Copy link

This appears to be an issue because 'IsNullOrWhiteSpace' is only available in dotnet 4. If you deploy to SQL Server that supports this version, ie 2014 it should work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants