RabbitMQ.Client 3.3.5 - Unable to create assembly in Sql Server 2008 R2.

[kumarasami....@nielsen.com]

Hi,

I have installed RabbitMQ client dll 3.3.5 by using msi file from our website.

I am using Sql Server 2008 R2.

I have created SQL CLR project with Dot net Framework 3.0. 

This project used RabbitMQ client dll.

I am getting error when i am creating assembly by using SQL CLR dll project code

I am getting below error

Error:

Msg 6503, Level 16, State 12, Line 1

Assembly 'rabbitmq.client, version=3.3.5.0, culture=neutral, publickeytoken=89e7d7c5feba84ce.' was not found in the SQL catalog.

So that I am trying to add RabbitMQ client on Sql Catalog.

There also I am unable to complete and error as

Error:

Msg 10301, Level 16, State 1, Line 1

Assembly 'RabbitMQ.Client' references assembly 'system.servicemodel, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

 

Please see attached file.

Please guide me.

Thanks  

[Michael Klishin]

> Assembly 'rabbitmq.client, version=3.3.5.0, …' was not found in the SQL catalog.

> The system cannot find the file specified

suggest the library wasn't added.

.NET client 3.3.x doesn't support SQL CLR. Later versions do (e.g. 3.6.3 does) but

require a newer .NET version.

--
You received this message because you are subscribed to the Google Groups "rabbitmq-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rabbitmq-user...@googlegroups.com.
To post to this group, send email to rabbitm...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

MK

Staff Software Engineer, Pivotal/RabbitMQ

[kumarasami....@nielsen.com]

There is no chance to change sql server version from 2008 r2.

I want to create SQL CLR dll with .net framework 2.0 and require that add this SQL CLR dll on Sql server 2008 r2.

What version of RabbitMQ client dll i need to refer on SQL CLR ?

I used dll from RabbitMQ.Client-v3.3.5-dotnet-2.0.zio

=> I am unable to build with framework 2.0. Visual studio informed that added namespace is not found.

=> I can build with framework 3.0, But i can't add SQL CLR dll on sql catalog in SQL Server 2008R2 

Could you please help me.

[Karl Nilsson]

Perhaps it is time to look at alternatives to running the RabbitMQ client inside SQL CLR on .NET 2.0. 

What is it you are trying to achieve? 

Could it perhaps be done using the HTTP API instead? I am sure it should be possible to craft an HTTP request inside SQL CLR.

https://cdn.rawgit.com/rabbitmq/rabbitmq-management/rabbitmq_v3_6_3/priv/www/api/index.html

Cheers

Karl

Karl Nilsson

Staff Software Engineer, Pivotal/RabbitMQ

[Michael Klishin]

Looks like it's 3.6.0+ (so, 3.6.3):

 * https://github.com/rabbitmq/rabbitmq-dotnet-client/issues/57

 * https://github.com/rabbitmq/rabbitmq-dotnet-client/issues/167

[Michael Klishin]

Or try a client for a different protocol that RabbitMQ supports, e.g. STOMP or MQTT.

On Wed, Jul 20, 2016 at 4:31 PM, Karl Nilsson <knil...@pivotal.io> wrote:

[kumarasami....@nielsen.com]

Thank you for your support