It appears the BizTalk SQL Adapter Wizard is unable to See CLR Stored Procs
(SQL 2005) - Anyone found a remedy for this? Hotfix perhaps?

Thx,
Coz

[ Post a follow-up to this message ]

It looks like there is a restriction on the SQL Adapter to use CLR
procedures.

There is a blog post about this issue at
http://www.caffedharma.com/tech/arc...ral/000211.html

As suggested in that blog, why don't you write a wrapper stored
procedure(regular), which in turn will call the CLR procedure.

Then  you can configure your SQL adapter to call the wrapper procedure
instead of calling CLR procedure directly.

--
Regards,
Saravana Kumar
http://www.biztalk247.com/v1/
http://www.digitaldeposit.net/blog
[Please mark the response as "Answer" if it solves your problem.]


"Coz" wrote:

> It appears the BizTalk SQL Adapter Wizard is unable to See CLR Stored Proc
s
> (SQL 2005) - Anyone found a remedy for this? Hotfix perhaps?
>
> Thx,
> Coz
>

[ Post a follow-up to this message ]

Thanks for your message...

I had seen the seen the blog you mentioned and considered the solution
mentioned, but I was hoping Microsoft is aware of the limitation and working
on a Hot Fix. Another problem is that of bringing back a record set into
BizTalk that contains a column of the XML data type in addition to other
fields.

Oh well...

Thanks,
Coz

"Saravana Kumar" wrote:
[vbcol=seagreen]
>
> It looks like there is a restriction on the SQL Adapter to use CLR
> procedures.
>
> There is a blog post about this issue at
> http://www.caffedharma.com/tech/arc...ral/000211.html
>
> As suggested in that blog, why don't you write a wrapper stored
> procedure(regular), which in turn will call the CLR procedure.
>
> Then  you can configure your SQL adapter to call the wrapper procedure
> instead of calling CLR procedure directly.
>
> --
> Regards,
> Saravana Kumar
> http://www.biztalk247.com/v1/
> http://www.digitaldeposit.net/blog
> [Please mark the response as "Answer" if it solves your problem.]
>
>
> "Coz" wrote:
> 

[ Post a follow-up to this message ]