search

WCOMAB / SqlServerSlackAPI

SqlServerSlackAPI is a SQL Server CLR assembly for direct communication with Slack via TSQL
Microsoft Public License
29 stars 7 forks source link

SQL server 2008 CLR version #4

Open SQLadmin opened 8 years ago

SQLadmin commented 8 years ago

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 commented 7 years ago

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.