You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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.
The text was updated successfully, but these errors were encountered: