Post reply

CLR function with temp table

  • June 9, 2008 at 5:14 pm

    #183319

    I have written a CLR function that posts product information to a web service.

    Every thing is working perfect but when I replace permanent tables with temp tables they are not accessible with in CLR function.

    Please help.

  • June 9, 2008 at 5:23 pm

    #826399

    I guess you are using a conventional DB connection string in your CLR function. If yes replace it with

    SqlConnection connection = new SqlConnection("context connection=true")

    This will use the connection of the calling context, therefore temporary tables in that context will be available to the CLR function.

    If this doesnt work or your have already done this than share the CLR code for further help

  • June 11, 2008 at 2:56 pm

    #827546

    GREAT..its working fine now..

    thanxx.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply