CLR Configuration option problem

Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.Krishna
Hi
"Krishna" wrote:

> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.

> how to redtify the error
> Regards
> T.A.Krishna
John
|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info

CLR Configuration option problem

Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.
> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info

CLR Configuration option problem

Hai,
I develope one application using .Net framework 2.0 and sql server
2005.Some time the following message displayed
Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
configuration option
how to redtify the error
Regards
T.A.KrishnaHi
"Krishna" wrote:

> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
>
This error normally refers to the 'CLR Integration' setting, which you can
set by using the Surface Area Configuration (SAC) tool. If you choose to set
the option by feature then under Database Engine you can see 'CLR
Integration' and the Enable CLR Integration checked box should be checked.

> how to redtify the error
> Regards
> T.A.Krishna
John|||Krishna wrote:
> Hai,
> I develope one application using .Net framework 2.0 and sql server
> 2005.Some time the following message displayed
> Exceution of user code .Net framework is disabled .Enabled 'clr' emabled
> configuration option
CLR integration is disabled by default.
You must change the configuration option:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Best regards,
Marcin Guzowski
http://guzowski.info

CLR Assemblies

From SQL 2005 docs (type "Designing Assemblies" in the index lookup; bottom
of the page):
Supported .NET Framework Assemblies
Users can refer to the following .NET Framework assemblies in SQL Server
2005 without registering them by using CREATE ASSEMBLY:
custommarshallers.dll
Microsoft.visualbasic.dll
Microsoft.visualc.dll
mscorlib.dll
system.data.dll
<snip> etc ...
Anyone know how? All I can think of is, for example:
CREATE TYPE dbo.Int32
EXTERNAL NAME mscorlib.[System.Int32]
But that errors with:
Msg 6267, Level 16, State 1, Line 1
Assembly "mscorlib" does not exist, or the user does not have permission to
reference it.
I may be reading that sentence wrong, but it sounds like you should be able
to register System.Int32 as a type in SQL 2005 (assuming it conforms to the
requirements for CLR UDTs), but how to refernece the assembly when it hasn't
been registered with CREATE ASSEMBLY? I don't think I'd actually want to use
core CLR types, but ran across it in the docs so now I'm curious.
Thanks - KHAs far as I know, there are a list of assemblies that are loaded from the
GAC by SQL Server and make available for use (since there is no need to
register them into each database). The rest of all asemblies (like user
assemblies) can only be loaded through CREATE ASSEMBLY.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"KH" <KH@.discussions.microsoft.com> wrote in message
news:2E6A8137-DA4B-4367-A688-AFCDF06FB913@.microsoft.com...
> From SQL 2005 docs (type "Designing Assemblies" in the index lookup;
> bottom
> of the page):
> Supported .NET Framework Assemblies
> Users can refer to the following .NET Framework assemblies in SQL Server
> 2005 without registering them by using CREATE ASSEMBLY:
> custommarshallers.dll
> Microsoft.visualbasic.dll
> Microsoft.visualc.dll
> mscorlib.dll
> system.data.dll
> <snip> etc ...
> Anyone know how? All I can think of is, for example:
> CREATE TYPE dbo.Int32
> EXTERNAL NAME mscorlib.[System.Int32]
> But that errors with:
> Msg 6267, Level 16, State 1, Line 1
> Assembly "mscorlib" does not exist, or the user does not have permission
> to
> reference it.
> I may be reading that sentence wrong, but it sounds like you should be
> able
> to register System.Int32 as a type in SQL 2005 (assuming it conforms to
> the
> requirements for CLR UDTs), but how to refernece the assembly when it
> hasn't
> been registered with CREATE ASSEMBLY? I don't think I'd actually want to
> use
> core CLR types, but ran across it in the docs so now I'm curious.
> Thanks - KH
>|||"examnotes" <KH@.discussions.microsoft.com> wrote in
news:2E6A8137-DA4B-4367-A688-AFCDF06FB913@.microsoft.com:

> Users can refer to the following .NET Framework assemblies in SQL
> Server 2005 without registering them by using CREATE ASSEMBLY:
>
"Refer to" above, means that you can have a dependency on the assembly
without having to catalogue the assembly directly through CREATE
ASSEMBLY (as Sri says in his post). In other words the assemblies
mentioned are the only ones that are allowed to be loaded from the GAC.
All other assebmlies have to be created in the database in question.
Niels
****************************************
**********
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
****************************************
**********

CLR .Net Framework 3.0

Hi

Is there any way to get the Sql 2005 to load the .Net 3.0 Framework instead of 2.0, when running a Stored Proc?

Thanks

You wouldn′t ask if you used SQLServer 2005 since beta :-) No, you can′t.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Actually the portion of the .NET Framework used by sqlclr is essentially exactly the same in .NET Framework 3.0 as .NET Framework 2.0. The BCL and CLR layers of the .NET Framework were (except for servicing fixes) unchanged and still return the same version in .NET Framework 3.0 as they did before.

See the MSDN documentation for more information on what exactly .NET Framework 3.0 entails: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnlong/html/netfx30.asp

So except for bug fixes, it doesn't matter to sqlclr whether your machine has .NET Framework 3.0 or 2.0 installed.

Steven

CLR .Net Framework 3.0

Hi

Is there any way to get the Sql 2005 to load the .Net 3.0 Framework instead of 2.0, when running a Stored Proc?

Thanks

You wouldn′t ask if you used SQLServer 2005 since beta :-) No, you can′t.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Actually the portion of the .NET Framework used by sqlclr is essentially exactly the same in .NET Framework 3.0 as .NET Framework 2.0. The BCL and CLR layers of the .NET Framework were (except for servicing fixes) unchanged and still return the same version in .NET Framework 3.0 as they did before.

See the MSDN documentation for more information on what exactly .NET Framework 3.0 entails: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnlong/html/netfx30.asp

So except for bug fixes, it doesn't matter to sqlclr whether your machine has .NET Framework 3.0 or 2.0 installed.

Steven

Client Report Builder Framework not being picked up

Just a question regarding what is required to use report builder from a client pc.

If i sit at client pc, and then click on the report builder, it promts me that framework 2 is required to run report builder. I then proceed to click on the given link to install framework 2 beta 2 , but yet once the install is complete, even after a reboot, if i click on the report builder button again from within RS , it still prompts me to install the framework?

If i view the source, i see that its just a modal window with the message on the click of the button,i have even cleared cache and temp files but no luck, so it obviously does this check as the http://webserver/reports site loads.

Am i missing something here, any help would be appreciated

Thanks in advance
Shaun

Ok, i have managed to figure it out,

I am using the lastest CTP for SQL2005 on the server,
When the client gets sent to the microsoft site, it seems to install with a different framework version.

I read a bit about this on the following link, if any one else has any hassles.
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=82579

So basically, to fix it, i have made a copy of the correct framework redistributable and installed that onto the client machines , then everything seems to work.

Regards,
Shaun